0 Replies Latest reply on Aug 8, 2011 4:58 AM by AndyJay2009

    Splitting search phrase for select statement

    AndyJay2009 Level 1

      Hi all...

      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