Might look here. http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=103033 Theres an example for locating an exact match that is simple, another example that uses like, but not sure you'd want to mess with it. (seems to be a convoluted way to use 'or')
I also found this, --select * from contacts where concat(last_name, ' ', first_name) like '%re%'-- Maybe you can do something this way. On Mon, Sep 17, 2012 at 10:29 AM, Klaus on-rev <[email protected]>wrote: > Hi Mark, > > Am 17.09.2012 um 18:25 schrieb Mark Schonewille < > [email protected]>: > > > 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 > [email protected] > > > _______________________________________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
