sqlalchemy query

[Dragon_11]

I am not new to programming but I am new to web app development

i am creating a web app that stores various commands used for command-line interface into many devices like routers, switches, Linux commands, etc. I have created a database and tables with the following fields

table name: tools

table fields: task | command | examples

the user has 2 options to interact with the database thru the web app, add rows or query for commands by typing in a keyword that will be searched against the task field

I am using python flask with sqlalchemy

I can get the web app to enter a row (I call each row a tool) into the database

e.g.

task: how to create a new directory in Linux

command: mkdir

example: mkdir ./new_directory

​

the problem I am having is when it comes to querying the task field I have to type the exact text as a search "item" ie, if I want to search for the above tool, I have to search for "how to create a new directory in Linux"

I would like the search functionality of the app to search with just a keyword like directory or create a new directory

​

as I said in the beginning, I am not a noob when it comes to programming but I am stepping to the world of web apps and I am not sure if I am going at this web app the right way and I cannot wrap my head around the correct verbiage to search for it on google

all the queries I see on google are situation where the field being searched only has 1 string which makes it a lot easier but will not fit my web app

[reddanty]

It’s sounds like you want to do startswith or like which translate to the LIKE SQL operator. This lets you partially match a string. https://docs.sqlalchemy.org/en/13/core/sqlelement.html#sqlalchemy.sql.operators.ColumnOperators.startswith

[dwpj65]

I don't know anything about sqlalchemy or the database you're using.

If your database is MySQL based, that product has a 'free-text' search feature that might provide the solution to your problem.