> database,sql,query > Hi All, > > Is there a nice way to take a search string eg > "America spying China" and search a text or > blob field for occurances of all of the words > in the text in any order (ie not just a literal > string match, but the equivalent of > AND X LIKE "%America%" AND X LIKE "%China%" AND > X LIKE "%spying%") > > I'm not on the list so please reply to this address. > > Thanks in advance, > > Mark. > > > -- > Mail Headers > > > -- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php