How to create virtual column using MySQL SELECT?

php mysql select
Skuta picture Skuta · Jan 18, 2009 · Viewed 129.1k times · Source

If I do SELECT a AS b and b is not a column in the table, would query create the "virtual" column?

in fact, I need to incorporate some virtual column into the query and process some information into the query so I can use it with each item later on.

Answer

Gabriel Sosa picture Gabriel Sosa · Jan 18, 2009

Something like:

SELECT id, email, IF(active = 1, 'enabled', 'disabled') AS account_status FROM users

This allows you to make operations and show it as columns.

EDIT:

you can also use joins and show operations as columns:

SELECT u.id, e.email, IF(c.id IS NULL, 'no selected', c.name) AS country
FROM users u LEFT JOIN countries c ON u.country_id = c.id

Related questions

How can I properly use a PDO object for a parameterized SELECT query

I've tried following the PHP.net instructions for doing SELECT queries but I am not sure the best way to go about doing this. I would like to use a parameterized SELECT query, if possible, to return the ID in …

Read More
Selecting all columns that start with XXX using a wildcard?

I have several columns in my databases with similar names. How do I select those based on the word they start with? Here's an example table layout: I tried selecting all info for a particular thing (food kind in this …

Read More
php select from mysql where title begins with A (and A alone)

I'm sure this is super easy, but can't seem to figure it out.. I need to select all titles from my database where the title starts with A, or B, or C etc. Here's what I've tried so far: SELECT * …

Read More