[thelist] mysql - like

jason.handby jason.handby at corestar.co.uk
Thu Aug 24 03:42:55 CDT 2006


> The next thing is searching on phrases so that if a search is 
> made on 'this word' results are returned for 'this' or 
> 'word'. Do you know any good resources for this stuff.

Using your server-side langage of choice, you could break your string
into individual words (by looking for white space) and then build your
WHERE clause accordingly:

  'this word'   becomes    MyCol LIKE '%this%' OR MyCol LIKE '%word%'



Jason



More information about the thelist mailing list