Change value from 1 To Yes In MySQL select statement

mysql sql case
Rocco The Taco picture Rocco The Taco · Feb 21, 2014 · Viewed 24.5k times · Source

I'm only able to SELECT on a table.

The table has a column called inty with a value of 0 or 1

I am currently selecting inty as:

SELECT inty AS InternetApproved FROM Table1

Is there a way to reformat the data within the SQL SELECT so that if the value is 0 make it No and if the value is 1 make it Yes for display purposes in the output SELECT results?

Answer

Deepak Rai picture Deepak Rai · Feb 21, 2014

Simple and easy way to achieve this is:

SELECT IF(inty = 1, 'YES', 'No') AS internetApproved FROM Table1

Related questions

Case statement in MySQL

I have a database table called 'tbl_transaction' with the following definition: id INT(11) Primary Key action_type ENUM('Expense', 'Income') action_heading VARCHAR (255) action_amount FLOAT I would like to generate two columns: Income Amt and Expense Amt. Is …

Read More
How do I use properly CASE..WHEN in MySQL

Here is a demo query, notice it is very simple, Fetches only where base_price is 0, And still, it chooses the condition 3: SELECT CASE course_enrollment_settings.base_price WHEN course_enrollment_settings.base_price = 0 THEN 1 WHEN course_enrollment_settings.…

Read More
Mysql SELECT CASE WHEN something then return field

I have two field nnmu and nnmi , if nnmu is equal to 1, I need to return naziv_mesta from **mesto_istovara**, else if it's =0 I need to return naziv_mesta from mesto_utovara table and reverse, if nnmi is equal …

Read More