0

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"

timmy
  • 35
  • 5

0 Answers0