Use nested select query in a where clausle MySql

Question

Hello i have a very old and BIG query which gous like this:

select id, someValue, (select x from y inner join x on x.y = y.zzz) as filter

Now i need to filter for the deliverd variable like

select id, someValue, (select x from y inner join x on x.y = y.zzz) as filter
WHERE filter not 'badPractise'

Is there any way i can use it without making the same join in the where clausule?

M Khalid Junaid · Accepted Answer · 2014-03-28 11:49:20Z

1

Yes you can use HAVING clause to filter out with your filter column

select id, someValue, 
(select x from y inner join x on x.y = y.zzz) as filter
FROM ....
HAVING filter <> 'badPractise'

answered Mar 28, 2014 at 11:49

M Khalid Junaid

64.6k10 gold badges93 silver badges120 bronze badges

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

1 Answer 1