Please show me a vB mod that provides searching by phrase. Here's the MySQL hack

[HydraulicJack]

Of the vB installs I've seen, it appears that it's only possible to search by a single word (e.g. "foo") or for posts containing a group of non-contiguous (or contiguous buried in a mountain of posts where the words are not contiguous (e.g., "foo, bar, sna, fu)), but not by a phrase, i.e. to return a list of posts containing only the words when in a contiguous phrase e.g., "foo bar sna fu".

Seems like since vB is based on MySQL that it's doable.
Does anyone know of a mod for vB that offers this keyphrase search option, and perhaps a link to it?

The following is what I'm talking about:

imho THIS MySQL query hack would make the info in a vB database WAAAAY more accessible than single-word poking around...

The following is from:
http://www.samspublishing.com/articles/article.asp?p=377068&seqNum=13&rl=1

A phrase search can be performed to require all words to be present in a particular order. Enclose the phrase within double quotes, and include punctuation and whitespace that is present in the phrase you want to match. In other words, you must specify the exact phrase:

mysql> SELECT * FROM apothegm
-> WHERE MATCH(attribution, phrase)
-> AGAINST('"bell book and candle"' IN BOOLEAN MODE);
Empty set (0.00 sec)
mysql> SELECT * FROM apothegm
-> WHERE MATCH(attribution, phrase)
-> AGAINST('"bell, book, and candle"' IN BOOLEAN MODE);
+---------------------+------------------------+
| attribution | phrase |
+---------------------+------------------------+
| Miguel de Cervantes | Bell, book, and candle |
+---------------------+------------------------+

:up: :up: :up:

[g7jgq]

Hiya

I have fulltext indexing on and 'boolean' searching enabled for usergroups

I have found the following

When using he advanced search if you search thread titles and use quotes around the search phrase it will do an exact match however when searching al post content its doing an OR.

If I can find the time I will delve into the code and see whats going on

Alex

[HydraulicJack]

Thanks for very much for jumping into it Alex - vB is so cool it should have the most robust search capabilities out t/here. Put more Know in Knowledge Base.

I'd also like to find out a/the hack for editing whatever templates or variables to put in this text on the search form - both the intial one and the advanced one:

To search for exact phrase "surround the phrase in double quotes".

Best,
Jack