'MySQL fulltext search - MATCH(column), where column = REPLACE(other_column,'\'','')

Need to find in table records both e.g. Cristy's Auction and Cristys Auction using fulltext search. I thought better do it - replace apostrophe in search query, also replace it in search data

SELECT REPLACE(other_column,'\'','') AS column FROM table
    WHERE MATCH(column) AGAINST(CONVERT('+Cristys +Auction' USING latin1) COLLATE latin1_german2_ci IN BOOLEAN MODE)

throws error Error Code: 1054. Unknown column 'column' in 'where clause', as expected.
Using REPLACE(other_column,''','') directly in MATCH, or HAVING instead WHERE throws errors too...
How can I solve my problem?

Upd. DB Fiddle

mysqlfull-text-search


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions