Pat
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
View this message in context:
http://www.nabble.com/how-to-match-all-words-tf3412448.html#a9705200
Sent from the MySQL - General mailing
Hey all,
I have a table 'clients' like this:
id int(5),
name varchar(55),
address varchar(55)
I would like to select all the records that have '%x%' and '%y%' but
'%x%' can be in name and '%y%' can be in address. Also in my query
there are generally more words to match (x,y,z,t etc) and I can't
At 09:32 PM 3/15/2007, you wrote:
Hey all,
I have a table 'clients' like this:
id int(5),
name varchar(55),
address varchar(55)
I would like to select all the records that have '%x%' and '%y%' but
'%x%' can be in name and '%y%' can be in address. Also in my query
there are generally more words