yes that gives the right results but i ask if i can do the same thing without enumerating all fields like this:
SELECT * FROM [tablename] WHERE Field1 LIKE '%text%' OR Field2 LIKE '%text%' OR ... What i want is to do the same thing without knowing what are the field names or how many fields this table has. I want to say : SELECT * FROM [tablename] WHERE [whatever field] LIKE '%text%' and if one or more fields in a record contain 'text' then this record is returned on the result.. quite tricky ha? if u have any idea please answer. Thanks a lot for your answer teo [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
