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 > kl...@major.on-rev.com > _______________________________________________ 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
