Re: MySQL fulltext indices and phrase search

"Jens Kisters" <newsletters@rosomm-partner.de> wrote: > Hi there, is there a possibility to use MySQL's MATCH ... AGAINST to > look for a string like "foo bar" ? > > if i MATCH keyname AGAINST ('foo bar') i get resuts that match foo or > bar, but not both of them separated by a space. > > My guess is that the organization of the index doesn't allow this kind > of search as it's based on single words , but maybe one of you has a > better idea than > to select the rows that contain both and hit those with LIKE '%foo bar%' Perhaps you should ask on the mysql list. List-Subscribe: <mailto:mysql-subscribe@lists.mysql.com> -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.com/