Does anyone know how to split my product search box phrases in to individual words and then base the select statement on each word, using OR ?
So if someone typed in Mickey Mouse Disney, the select statement would search for all records with Mickey OR Mouse OR Disney in the title?
At the moment im using a straight LIKE statement which isn't very intelligent. If someone typed in Mickey Disney, nothing would be found :-(
Hope someone can advise and possible let me know how you overcame this problem.
Thanks in advance
Retrieving data ...