Is it possible perform a fulltext search on MySQL 8.0, with double quotes and wildcard?
2
votes
1
answer
912
views
Based on past answers, I see that it was previously possible to perform fulltext searches with double quotes and wildcard, like the following:
SELECT COUNT(*) FROM mytable MATCH (mycolumn) AGAINST ('"myemail@gma"*');
however, when I try this on the latest MySQL version(s), 8.0.25, I get an error:
ERROR 1064 (42000): syntax error, unexpected $end, expecting FTS_TERM or FTS_NUMB or '*'
Is there any way to make this type of search work?
The only alternative I can see, in the email case, is to search the terms separated, with an AND condition (e.g. '+myemail +gma*', assuming stopwords disabled), but the semantics of the search are different.
Asked by Marcus
(390 rep)
Sep 29, 2021, 11:02 AM
Last activity: May 29, 2025, 04:07 PM
Last activity: May 29, 2025, 04:07 PM