select where everything like '%$variable%'

[runelore]

hi there, i know that if i wanna select comething from a database i use : "select from table where name like @%$variable%' or name like @%$variable%' etc..." but how to di do a select where i match every field to the like variable, i tried "select from table where * like '%$variable%'" but that didnt work, please help, i don't wanna have to write out a long line of where like commands in my select statement... thansk

[notionlogic]

As far as I'm aware, you've got no choice...it's the long winded query or nothing!

Mind you, if I'm proved wrong that's great cos I could use it too!

[runelore]

Thanks as lot for replying, will stick to the long way then.... thanks again..

[Nick_Whymark]

You could do something like:

"select * from table where concat(fielda, fieldb, fieldc ...) like '%$variable%'"

which would find any row where your like string matches one or more of the fields in the concat function (so it's a logical "or" rather than an "and")

Nick.

[runelore]

That is perfect,. thank you very mmuch, is exactly what i was looking for, makes it a lot easier, thanks again...