OK I know 'and' is a stopword. I still need this to work. I want to search a field in a table for the phrase 'and more' using speedy full-text search. The problem I'm having is that this query returns no records:
EDIT: i have 'and more' in quotes:
SELECT * FROM products_description WHERE MATCH(products_description) AGAINST ('"and more"' IN BOOLEAN MODE);
I know for a fact there is such a record because this returns about 52 records:
SELECT * FROM products_description WHERE products_description LIKE '%and more%'
The problem with using LIKE is that it is so very slow. I was imagining that using MATCH/AGAINST and a ft index would speed things up.
Any advice about being able to search this field for the exact phrase 'and more' would be much appreciated.
