I am shocked.

I spent past 3-4 days figuring out how I could implement stemming (and synonyms searches) in mysql when I see in SQL Server the query is incredibly easly:

  • Visual Studio not showing server name when adding connection
  • My Merge statement is failing
  • Select Min And Max Value from one table with same id in one row (sql server)
  • End User Authentication using Neo4j
  • Conversion failed when converting date and/or time from character string while inserting datetime
  • Safest way to get last record ID from a table
  • Select * from tab where CONTAINS(*,'FORMSOF(THESAURUS,word)')

    Is possibile on MySql there isn’t anything like that?

    One Solution collect form web for “SQL Server vs MySQL: CONTAINS(*,'FORMSOF(THESAURUS,word)')”

    No, MySQL does not support matching against a user-provided thesaurus.

    You can use an external FULLTEXT engine like Sphinx which supports morphology rules, has several stemmers and thesauri built in and allows pluggable ones.

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.