Edwin Aw
Edwin Aw

Reputation: 130

Matching column with words separated by comma

I have a category column with values separated by comma, ie, "menu, brochure". How can I retrieve row which is matching either menu or brochure?

Thank you.

Upvotes: 0

Views: 137

Answers (1)

echo_Me
echo_Me

Reputation: 37243

you can use FIND_IN_SET or LIKE

Upvotes: 2

Related Questions