Re: Hyphen in FULLTEXT

[Jon Stephens]

I think it's likely that the '-' characters are being interpreted as search operators.

I'm also not sure why you encase the search string with two sets of quotes. Note that single quotes and double quotes cause different behaviour.

MATCH(column) AGAINST('$strings' IN BOOLEAN MODE) is intended to search for text columns in which the string or strings given in AGAINST() are present (+) and/or absent (-). As you're using it here, you might as well just use SELECT value FROM table WHERE value = $string.

See https://dev.mysql.com/doc/refman/8.2/en/fulltext-boolean.html for more info and examples.

Another alternative for finding columns in which a given string is present is to use LIKE--see https://dev.mysql.com/doc/refman/8.2/en/string-comparison-functions.html#operator_like.

cheers

Jon Stephens
MySQL Documentation Team @ Oracle

MySQL Dev Zone
MySQL Server Documentation
Oracle