SQL question

[Klaus on-rev]

Hi Mark,

Am 17.09.2012 um 18:25 schrieb Mark Schonewille <m.schonewille at economy-x-talk.com>:

> Hi Klaus,
> 
> The easy way to do this is to retrieve all column names, use a script (PHP or LiveCode) to create the syntax for searching all columns with OR statements and use another statement to retrieve the data with your now dynamic SQL syntax.

thanks a lot, I was afraid of that :-D

> MySQL has no built-in way to do this.

Ah, and SQLite probably not, too.

> --
> Best regards,
> 
> Mark Schonewille

Best

Klaus

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