SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE eployees ( `name` VARCHAR(64), `status` VARCHAR(64) ); INSERT INTO eployees VALUES ("Frank", "online"), ("Toby", "away"), ("Frank", "busy"), ("Alice", "offline"), ("Alex", "away"), ("Toby", "online"); SELECT `name`, CASE WHEN `statuses` LIKE '%busy%' THEN 'busy' WHEN `statuses` LIKE '%online%' AND `statuses` NOT LIKE '%busy%' THEN 'available' WHEN `statuses` NOT LIKE '%online%' AND `statuses` NOT LIKE '%busy%' THEN 'not available' END `status` FROM ( SELECT `name`, GROUP_CONCAT(`status`) `statuses` FROM eployees GROUP BY `name` ) emploees_statuses;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear