hello, I would like to ask if it is possible with mysql to do soomething like this:
SELECT * FROM [specific table name] WHERE [WHATEVER FIELD(not specified)] LIKE '%sometext%' Is there a variable lets say to refer to the column name? What I actually want to do is to find all records that fields of a specific value without specifing the field name. To search for a string in a table but not say in what field (search in all fields) i want to know if that can be done with a single query. thanks a lot in advance 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
