SQL question

[Mark Schonewille]

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.

MySQL has no built-in way to do this.

--
Best regards,

Mark Schonewille

Economy-x-Talk Consulting and Software Engineering
Homepage: http://economy-x-talk.com
Twitter: http://twitter.com/xtalkprogrammer
KvK: 50277553

Use Color Converter to convert CMYK, RGB, RAL, XYZ, H.Lab and other colour spaces. http://www.color-converter.com



On 17 sep 2012, at 17:59, Klaus on-rev wrote:

> Hi friends,
> 
> I know that we can use WILDCARDS in database searches with "LIKE"
> ...
> SELECT * FROM Persons WHERE City LIKE 'sa%'
> ...
> 
> I am wondering if it is possible to search the complete table instead of a particular column.
> Know what I mean? Like this pseudocode:
> ...
> SELECT * FROM Persons WHERE ANY_COLUMN LIKE 'sa%'
> ...
> 
> Thanks for any hints or workarounds if this is not possible ;-)
> 
> 
> Best
> 
> Klaus
> 
> --
> Klaus Major
> http://www.major-k.de
> klaus at major.on-rev.com
>