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
