Re: Fulltext search for 2 words close to each other

2001-03-25 Thread Sergei Golubchik
Hi! On Mar 25, Ovanes Manucharyan wrote: > Hello, > > I am trying to search for 2 words which are close to each other.. > In fact, its a name so it should either occur as John, Doe or John Doe > in my fulltext index.. (this particular table is full of emails) > > select id,message_subject from

Fulltext search for 2 words close to each other

2001-03-25 Thread Ovanes Manucharyan
Hello, I am trying to search for 2 words which are close to each other.. In fact, its a name so it should either occur as John, Doe or John Doe in my fulltext index.. (this particular table is full of emails) select id,message_subject from email WHERE MATCH(message_body,message_subject) against