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. :-)
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
