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

    Splitting search phrase for select statement

    AndyJay2009

      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


      Andy