MYSQL Match string in column

Question

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

"gender:male,eye_color:blue,province:12"

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

Thanks in advance

select * from tablename where gender='male' AND province='12'; — Jigar
– Jigar, Commented Apr 18, 2016 at 3:49
@DarjiJigar column name? I'm talking about the content of a column, I don't specify a column name in the question — avolquez
– avolquez, Commented Apr 18, 2016 at 3:50

Blank · Accepted Answer · 2016-04-18 03:53:20Z

3

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%'

answered Apr 18, 2016 at 3:53

Blank

12.4k1 gold badge16 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1