How can I use MySQL IF() function within SELECT statement?

It is quite possible to use MySQL IF() function within SELECT statement by providing the name of the column along with a condition as the first argument of IF() function. To understand it, consider the following data from table ‘Students’.

mysql> Select * from Students;
+----+-----------+-----------+----------+----------------+
| id | Name      | Country   | Language | Course         |
+----+-----------+-----------+----------+----------------+
| 1  | Francis   | UK        | English  | Literature     |
| 2  | Rick      | USA       | English  | History        |
| 3  | Correy    | USA       | English  | Computers      |
| 4  | Shane     | France    | French   | Computers      |
| 5  | Validimir | Russia    | Russian  | Computers      |
| 6  | Steve     | Australia | English  | Geoinformatics |
| 7  | Rahul     | India     | Hindi    | Yoga           |
| 8 | Harshit | India | Hindi | Computers |
+----+-----------+-----------+----------+----------------+
8 rows in set (0.00 sec)

Now, with the help of the following query, having IF() function within SELECT statement, we are going to get the names and course details of the Students and if they have the English Language then it writes ‘Eng_Language’ otherwise ‘Other language’.

mysql> Select Name, IF(Language = 'English', "Eng_Language", "Other Language") AS 'Native Language', Course from students;
+-----------+-----------------+----------------+
| Name      | Native Language | Course         |
+-----------+-----------------+----------------+
| Francis   | Eng_Language    | Literature     |
| Rick      | Eng_Language    | History        |
| Correy    | Eng_Language    | Computers      |
| Shane     | Other Language  | Computers      |
| Validimir | Other Language  | Computers      |
| Steve     | Eng_Language    | Geoinformatics |
| Rahul     | Other Language  | Yoga           |
| Harshit   | Other Language  | Computers      |
+-----------+-----------------+----------------+
8 rows in set (0.00 sec)

Monica Mona

Published on 21-Feb-2018 05:38:17

• Related Questions & Answers
• How can I use a SELECT statement as an argument of MySQL IF() function?
• IF() function in a MySQL Select statement?
• How MySQL evaluates if I will use an expression within SUM() function?
• How to use the CAST function in a MySQL SELECT statement?
• MySQL SELECT IF statement with OR?
• Can we use SELECT NULL statement in a MySQL query?
• How to use NULL in MySQL SELECT statement?
• How MySQL evaluates when I use a conditional expression within SUM() function?
• How can I use goto statement in JavaScript?
• How can I use another MySQL function/s with REPEAT() function?
• Can I use SUM() with IF() in MySQL?
• How can column data be used within MySQL CASE statement?
• How can I use SPACE() function with MySQL WHERE clause?
• How to use a select statement while updating in MySQL?
• How can I use MySQL IN() function to compare row constructors?