Search for column value in a string variable?

[Barry Newton]

Hi. . .I'm trying to be lazy and write a query where I stuff a list of 
names into a variable (@namelist), and then try to find items in column 
lastname which appear anywhere in that list.  It doesn't want to work, 
and even regexp isn't working, though that's probably my fault.  Any 
suggestions?  I'm completely open to various possibilities of delimiters 
in the namelist.

Obviously this would let me reuse the query over and over, just changing 
the one line.
--
Barry


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]