[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