- Instant help with your Sql coding problems

Use IF statement in MySQL

How to use IF statement in MySQL?
SELECT IF(status = 1, 'ACTIVE', 'INACTIVE') FROM task;

In MySQL, if you want a simple filed value conversion depending on a condition you can use the IF statement. For example, if you have a field that stores whether the actual task is active or not and is stored as a TINYINT . In this case, 0 means Inactive and 1 means Active. To return a human-readable format in an SQL query use the IF function as follows:

SELECT IF(status = 1, 'Active', 'Inactive') from task;

MySQL IF reference
Share "How to use IF statement in MySQL?"
Related snippets:
if, statement, use, then, MySQL, MariaDB, sql, query
Technical term:
Use IF statement in MySQL