How to full-text search in MySQL database in a column as string type with multiple values separated by ","
For example:
mysql_column -> ids: "FE,BE,PY", "FE", "FE_1"
Usign regexp function (or another mysql function), get only rows where ids column contains that IDs (only full values): "FE"
expected outcome:(2 rows) rows1: "FE,BE,PY", rows2: "FE" without "FE_1"