CODEWITHSUNDEEP
mysqlsubquery
112233
112233

Reputation: 2466

Subqueries with EXISTS

I want to select main menu if each of it has submenu in another table. Below is my query:

SELECT * FROM main_menu  m WHERE EXIST('select * from menu w where w.main_menu_id = m.main_menu_id')

But phpmyadmin gives an error which reads:

 #1305 - FUNCTION smartsaf_maxura.EXIST does not exist

Can anyone explain what went wrongly here?

Upvotes: 0

Views: 38

Answers (1)

user3600910
user3600910

Reputation: 3109

This shuld work

SELECT * FROM main_menu  m WHERE EXISTS(select * from menu w where w.main_menu_id = m.main_menu_id)

Upvotes: 1

Related Questions