How should a user query be searched?

Question

JavaScript

Hello.
I have a sqlite database with objects that oddly enough have names. I work with it through sequelize. How can I search the database not by the whole name, but partially (by the first letter, for example)?

Answer 1

Learn a minimum of SQL DML.
And if for the lazy and impudent, then the selection according to the Where condition allows you to specify a mask. "... where 'name' like 'andy%'..."
In this case, those rows will be selected whose name field starts with 'andy'