Closed aborn closed 1 year ago
if we have a table with column tags， the column value of tags is comma split string, like："a,b,c" we want to quey it by 'querytag' (ex 'a'), using follow sql：
table
tags
SELECT * FROM table WHERE FIND_IN_SET('a', table.tags);
if we have a
tablewith columntags， the column value oftagsis comma split string, like："a,b,c" we want to quey it by 'querytag' (ex 'a'), using follow sql：SELECT * FROM table WHERE FIND_IN_SET('a', table.tags);