Unable to ask a simple question in Base

I have a Base of recipes. I want to ask a simple query. Example - In the recipe name I want to know what recipes contains the word chicken in the name. Is there a source of information on what the proper code or formula to use?

The following should give an example of SQL to use. If doing this from a form, you may want to to use a filter. If straight from a query, you may want a parameter for the variable selection:

SELECT * FROM  "YOUR_TABLE" WHERE   UPPER ( "FIELD_TO EXAMINE") LIKE  UPPER ( CONCAT('%',ITEM_FIELD_PARAMETER_HERE_TO_COMPARE_TO,'%') )

@Spur52 When responding to an answer please use comment below the answer responding to, not another answer.

This is nothing more than SQL, the language to communicate to DB’s. Each DB might be using a different standard plus some variations so it is best to view the corresponding documentation. If using the default DB in Base, that would be HSQLDB embedded v1.8 - document found here.

There are also many web sites with information - here is one.

If this answers your question please click on the :heavy_check_mark: (upper left area of answer).

See - That is exactly what I am talking about. What resource can I use to learn what you just said?