Hello there,
I was wondering how I could make a specific type of search when the string has more
than one word.
Ex.---------------------------------------------
String = "Green Apple"
Select * from fruits
where
(fruits.color like '%Green Apple%'
or fruits.type like '%Green Apple%')
------------------------------------------------
What I thought was breaking the string in 2 words and compares each word with the
fields. The problem is that I can't control how many fields should be compared.
Also don't know how to compare each word. The following syntax doesn't work:
-----------------------------------------------
Select * from fruits
where
(fruits.color like in ('%Green%', '%Apple%')
or fruits.type like in ('%Green%', '%Apple%')
-----------------------------------------------
Any ideas would be very thankful.
Cheer's
Rui Monteiro
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
