oletob oletob - 6 months ago 12x
SQL Question

MYSQL Match string in column

I have a text inside a column and I want to make a search within this text but with only some words, for example:


How can I perform a query to match just "gender:male,province:12" in this text?

Thanks in advance


You mean this or not, just try it, I don't even know it works for your demand;)

select * from @table where @column like '%gender:male,%province:12%'