Latest news:

New android application Islamic Video has been released. its a free islamic video application for android smartphone. Download now!

How to create virtual column using MySQL SELECT?

something like

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

this allow you to make operations and show it as columns.


you can also use joins and show operaitons as columns:

    SELECT,, IF( IS NULL, 'no selected', as country
FROM users u LEFT JOIN countries c ON u.country_id =

See the

for refference

Tags : MySQL,

Views : 1339

Recent Posts


Popular Tags


Subscribe Us

Follow Us