从URL路径获取多个结果的查询

Question

从URL 'http://www.example.com/community/teams/photo-gallery‘。如何使用路径/community/teams/photo-gallery查询数据库以获得菜单的结果。请注意菜单中的弹格并不是唯一的。

所以这意味着只有关于community，teams，photo-gallery的结果才能显示出来。

，这是我的尝试，

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

这个查询在我的情况下不起作用

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

数据库结构

​

Answer 1

尝试：

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

或

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

Answer 2

就这样？o.o

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

还是你在说这个？htaccess url rewriting, ignoring files