mysql syntax error, unexpected '(', expecting FTS_TERM or FTS_NUMB or '*' 에러 발생시
mysql 에서 fulltext 검색시에 발생되는 에러이다.
https://dev.mysql.com/doc/refman/8.0/en/fulltext-boolean.html
MySQL :: MySQL 8.0 Reference Manual :: 12.9.2 Boolean Full-Text Searches
12.9.2 Boolean Full-Text Searches MySQL can perform boolean full-text searches using the IN BOOLEAN MODE modifier. With this modifier, certain characters have special meaning at the beginning or end of words in the search string. In the following query, th
dev.mysql.com
우선 mysql8.0 reperence에는
InnoDB full-text search does not support the use of a leading plus sign with wildcard ('+*'), a plus and minus sign combination ('+-'), or leading a plus and minus sign combination ('+-apple'). These invalid queries return a syntax error.
라고 나와있다.
full-text 검색시에 wild card 는 * 이고, ('+-') 의 문자와 함께 사용하지 못한다고 나와있다.