search - partial matches do not display

[jelie]

We'd like to be able to search using partial matches even if an exact match is found. How do we do this?

For example:

If we search on 3 letters or less, the phpMyFAQ returns results of everything that contains those letters. If we search on 4 letters or more, it will return search results of ONLY the exact match if an exact match exists.

In this case, we tried to use the letters CONN to find the word CONNECTICUT, but instead the search result only displayed the exact match of NATIONAL CONN COLLEGE.

[Thorsten]

Hi,

you can use the following logic: http://dev.mysql.com/doc/refman/5.5/en/ ... olean.html

bye
Thorsten