Most engines have a concatenate command, something like;
WHERE CONCAT(name, tags, comment) LIKE '%tUserInput%'
:)
Quoting Klaus major-k <kl...@major-k.de>:
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
kl...@major-k.de
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
