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? mfg Christian Eichert -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]