At 12:04 PM +0200 9/14/03, mo...@multimedia.homelinux.org wrote:
I have a very strange table.
Its cols are changing dynamicly.
Not all cols are all the time in the list.
Now I'd like to know if "something" is in any of the fields contended.
I'd like to make a "SELECT * FROM table WHERE any field contains 'something' "
I dont wand a workaround ... I know I could read the rows in a array
and so on search for 'something'
I tryed "SELECT * FROM table WHERE contains(*, 'something')" but it
is not working
any ideea?
Sorry. You'll have to know what the columns are, and you'll have to
include a condition in the WHERE clause that tests each column explicitly.
That may seem like a lot of messing around to you, which is a clue that
it may be a good idea to reconsider your table design. :-)
Are you MySQL certified? http://www.mysql.com/certification/
2 messages in com.mysql.lists.mysqlRe: selecting in ALL colls of a table
