SQL query return True/False

Question

I am working with an existing architecture which populates fields on a form with things from the database. The form is entirely database driven and is done in PHP and MySQL.

The problem is that the database table that holds the form elements has a field for the query that will return a result set that will be used to populate the select dropdown form element. This works great for fields like States, countries, and other such fields which are particular to our organization.

I am implementing a new field and want to put a query in that returns a simple resultset {True, False} but I don't want to create a new database table that simply has those two as options, but need to keep it within the framework, so I need a SQL query to return the resultset which will be used to populate the form element.

Is there some kind of a SQL query that will just return the resultset {True, False} so that I can avoid making a table just to house those two options?

Answer 1

SELECT 'True' UNION SELECT 'False';

Answer 2

SELECT 'true' AS [state] UNION ALL SELECT 'false'

Answer 3

You mean something like this?:

select 'True' as value
union all
select 'False' as value

I'm guessing there is something more complex you are looking for?

Answer 4

You could serialize an array for storage in the database as a string and unserialize it on the way out.

$array = array(true, false);

Going into the db:

serialize($array);

Coming out of the db:

unserialize(YOUR_DB_RESULT_HERE);

Answer 5

I don't know if this query would work in MySql, but in SQL Server it works.

You can do that query:

SELECT 'True'
UNION
SELECT 'False'

You don't have to specify a table. You can do that for any value that you need, for any type of data.