Ask Your Question
0

Unable to ask a simple question in Base

asked 2017-09-09 17:36:25 +0200

Spur52 gravatar image

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?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2017-09-09 17:54:31 +0200

Ratslinger gravatar image

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,'%') )
edit flag offensive delete link more

Comments

@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.

Ratslinger gravatar imageRatslinger ( 2017-09-09 18:29:27 +0200 )edit

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

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

Ratslinger gravatar imageRatslinger ( 2017-09-09 18:30:38 +0200 )edit
0

answered 2017-09-09 18:18:17 +0200

Spur52 gravatar image

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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-09-09 17:36:25 +0200

Seen: 115 times

Last updated: Sep 09 '17