“IF” is a conditional statement in MySQL that allows you to execute specific code based on whether a certain condition is true or false.
The syntax for the IF statement in MySQL is:
IF(condition, value if true, value if false)
For example, if we want to check if a number is greater than 10 and return “Yes” if it is true or “No” if it is false, we can use the following query:
SELECT IF(5>10, ‘Yes’, ‘No’)
This will return “No” because the condition (5>10) is false.
We can also use IF statements in SQL queries to perform different actions depending on the results of the condition. For example:
UPDATE employees SET salary = IF(salary < 50000, salary*1.1, salary*1.05) WHERE department = ‘Sales’;
This query will update the “salary” column for all employees in the Sales department. If their current salary is less than 50000, it will increase by 10%. Otherwise, it will increase by 5%.
