Best way to query multiple 'categories' mysql php?

Question

I am probably overlooking something simple--

Some of the news items has 2 categories checked, and other times it has all 4 check. I know I can do OR '' OR '' OR '' OR '' -- but I think there is a better way.

The question: How could I query this to output: if the story has category 10,13 or 10,13,15 or 10,13,15,16 or 10,15 or 10,13?? ('10' is the parent category) -- without doing a query like that??

WHERE news.id = story.post_id AND news.category LIKE '10,13,15,16'

Your schema perplexes me a bit. Perhaps category be its own table (categories) and then you can use a categories_news cross-reference table. Just a suggestion. — webbiedave
– webbiedave, Commented Oct 16, 2010 at 15:00

Justin Ethier · Accepted Answer · 2010-10-16 14:42:15Z

1

You could say:

AND new.category IN ('10,13', '10,13,15', '10,13,15,16', '10,15', '10,13')

Which is slightly cleaner that using many OR's.

answered Oct 16, 2010 at 14:42

Justin Ethier

135k53 gold badges235 silver badges291 bronze badges

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

1 Comment

eberswine Over a year ago

Thanks. I didn't realize you can query "IN" ha.

cherouvim · Accepted Answer · 2010-10-16 14:40:36Z

0

WHERE news.id = story.post_id AND news.category in (10, 13, 15, 16)

answered Oct 16, 2010 at 14:40

cherouvim

32k15 gold badges107 silver badges158 bronze badges

Collectives™ on Stack Overflow

Best way to query multiple 'categories' mysql php?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related