I have been trying to implement FULLTEXT indexing in a very long table with varchars
and text fields that require LIKE '%something%' a lot.
I managed to index and change all queries to use AGAINST and etc. but the users didn't
like it. They say they really need the functioning of '%text%'.
Sending 'protect' from the app they want to receive:
1) 'the protection'
2) 'protecting the whales'
3) 'please protect me'
and not:
1) 'please protect me'
as happens with FULLTEXT indexing.
Is there a way to index a '%text%' like string? Using fulltext? Something else?
Couldn't find on the manual....
Thanks a lot,
Tiago Luchini
Diretor Técnico-Comercial
Galluch Soluções Internet
Telefax: 11 6912 3255
Celular: 11 3176 7740
http://www.galluch.com.br/