EN
MySQL - SELECT IF example
0 points
In this article, we would like to show you SELECT statement with IF function in MySQL.
Quick solution:
xxxxxxxxxx1
UPDATE `table_name`2
SET `column_name` = IF(condition , if_true, if_false);To show SELECT statement with IF function example, we will use the following users table:
Note:
At the end of this article you can find database preparation SQL queries.
In this example, we will use SELECT IF to display salary_info.
We select salary column, and if its value is > 4000 the IF function returns 'high_salary', otherwise it returns 'low_salary'.
Query:
xxxxxxxxxx1
SELECT `id`, `salary`,2
IF(`salary` > 4000, 'high_salary', 'low_salary') AS 'salary_info'3
FROM `users`;Output:
Note:
Go to this article to see more
IF()function practical examples.
create_tables.sql file:
xxxxxxxxxx1
CREATE TABLE `users` (2
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,3
`name` VARCHAR(50) NOT NULL,4
`surname` VARCHAR(50) NOT NULL,5
`department_id` INT(10) UNSIGNED,6
`salary` DECIMAL(15,2) NOT NULL,7
PRIMARY KEY (`id`)8
);insert_data.sql file:
xxxxxxxxxx1
INSERT INTO `users`2
( `name`, `surname`, `department_id`, `salary`)3
VALUES4
('John', 'Stewart', 1, '3512.00'),5
('Chris', 'Brown', 2, '1344.00'),6
('Kate', 'Lewis', 3, '6574.00'),7
('Ailisa', 'Gomez', 1, '6500.00'),8
('Gwendolyn', 'James', 2, '4200.00'),9
('Simon', 'Collins', 4, '3320.00'),10
('Taylor', 'Martin', 2, '1500.00'),11
('Andrew', 'Thompson', 1, '2100.00');