Re: Strange issue with fulltext searching (is "self" reserved)?

It isn't a reserved word, but "self" is a full-text stopword, so it isn't indexed. If you've built from source, the stopwords are in path-to-source/myisam/ft_static.c You can create your own stopword list, or turn off stopwords altogether, if you want. See

Strange issue with fulltext searching (is "self" reserved)?

I have a problem with searching for a specific term. I have a database of about 50k names, and am attempting to search the lastname field for 'self'. My query looks something like this: SELECT * FROM users where MATCH (first_name, last_name) against ('self'). This query works fine if I use any o