What's the best MySQL alternative to dual?

Question

So, primarily I work in oracle and have gotten spoiled by working with dual. For a user with select privileges on a given database how could you reproduce the dual functionality?

IE:

Select 'foo' from dual

Probably a very simple answer that I'm just missing.

Answer 1

I remember using Select 1 from dual in oracle and just select 1; in mysql. So I think you just try without a table reference.

This was to verify connectivity so not sure if it applies in your case.