Quick SQL question

Klaus major-k klaus at major-k.de
Mon Jul 15 08:19:51 EDT 2013


Hi firends,

with a table consisting of 3 (or more) db fields:
name
tags
comment

If I want to find a value in ALL of the three (or more) db fields, I now use:
...
## Pseudocode, quotes etc missing, I know!
put fld "searchfield" into tUserInput
select * from myTable where name LIKE %tUserInput% OR tags LIKE %tUserInput% OR comments  LIKE %tUserInput%
...
You get the picture :-)

Now my question: Is there a shorter SQL command for my purpose, that I did not find yet? 
Thanks in advance!


Best

Klaus
--
Klaus Major
http://www.major-k.de
klaus at major-k.de





More information about the use-livecode mailing list