MYSQL query in fetching data?

Question

I have a table of following structure:

I want a mysql query to select the category where subcategory = 2171. Here i want to fetch categories having subcategories ["2171","2172"] and ["2171"] which means that subcategories that includes "2171".

Nick · Accepted Answer · 2017-04-09 09:38:58Z

2

Try:

SELECT category FROM myTable WHERE subcategory LIKE( '%"2171"%' )

Putting the double quotes around it will stop false matches on something like 21717.

answered Apr 9, 2017 at 9:38

Nick

5,20519 gold badges35 silver badges52 bronze badges

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

Collectives™ on Stack Overflow

MYSQL query in fetching data?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related