How to select an empty result set?

March 26, 2023 by Tarik

There’s a dummy-table in MySQL called ‘dual’, which you should be able to use.

select
    1
from
    dual
where
    false

This will always give you an empty result.