MySQL MATCH search character limit

Databases
1

My application is on shared hosting. I therefore cannot alter ft_min_word_len.

I’m searching records which contain important two-character abbreviations.

Do I need to move to a dedicated server in order to be able to include two-character abbreviations within my search results or is there another way?

Thanks.

2

This has been a massive help.

Many, many thanks :slight_smile:

3

use LIKE instead of fulltext searching

4

I shall take a look.

Many thanks!

5

Can you sort by relevance with LIKE though?

i.e. with MATCH I’m doing this:
MATCH( table.colname, table.colname2 ) AGAINST(‘“.$var.”’) AS rel FROM table ORDER BY rel DESC

Thanks

6

yes :slight_smile:

maybe this will help… http://r937.com/keyword_relevance.html