I have a CMS that requires a SQL query to return options/values for a dropdown... typically it returns the rows from the table in the SQL query and fills in the dropdown options. Sometimes I just want to have two static options in the dropdown and do not want to create a whole table to manage those two unchanging items.
My questions is: Is there a MySQL query that will not query a table but will just return some static results as if it were querying a table?
Ideally I would like something similar to this (but static):
SELECT value FROM `fake_table`
And return the following:
value
//////////////
Option One
Option Two
Option Three
Etc...
Thanks in advance for any help!
select 'Option One' as Value
union
select 'Option Two' as Value
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With