Thank you Pyay Nyein.

That is one of the most useful answers. Makes the whole query look way simpler than CASE statements in the WHERE clause.