Query to get multiple results from URL path

Question

From the URL 'http://www.example.com/community/teams/photo-gallery'. Using the path /community/teams/photo-gallery how can I query the database to get the results of the menu. Please note that the menu slug are not unique.

So that means only results about community, teams, photo-gallery should show.

Here is my attempt

SELECT * FROM menu WHERE menu_slug = 'community' AND menu_slug = 'teams' AND menu_slug = 'photo-gallery'

This Query won't work in my situation

SELECT * FROM menu WHERE menu_slug = 'community' OR menu_slug = 'teams' OR menu_slug = 'photo-gallery'

Database Struture

score 0 · Answer 1 · answered Sep 05 '15 at 09:06

0

Try:

SELECT * FROM menu WHERE menu_slug = 'community' OR menu_slug = 'teams' OR menu_slug = 'photo-gallery';

OR

SELECT * FROM menu WHERE menu_slug IN ('community', 'teams', 'photo-gallery');

answered Sep 05 '15 at 09:06

Bernd Buffen

14,525
2
24
39

Thanks for your answer, but in my issue it won't work since my `menu_slug` is not unique. – Red Virus Sep 05 '15 at 09:08

score 0 · Answer 2 · edited May 23 '17 at 11:44

0

Just it? o.o

SELECT * FROM menu WHERE menu_slug = 'community' OR menu_slug = 'teams' OR menu_slug = 'photo-gallery'

Or you're talking about this? htaccess url rewriting, ignoring files

edited May 23 '17 at 11:44

Community

1
1

answered Sep 05 '15 at 09:06

KodornaRocks

425
3
14

Thanks for your answer, but in my issue it won't work since my `menu_slug` is not unique. – Red Virus Sep 05 '15 at 09:08
@Red Virus What do you mean? You mean that you want to do a Wildcard search? Post the error you get – KodornaRocks Sep 05 '15 at 09:09

Query to get multiple results from URL path

2 Answers2