| MySQL | ||
| The SQL Standard is the CASE statement | ||
| Specific to MySQL | ||
The IF function is also available:
SELECT title,
score,
IF(score>8.5,'Excellent','OK')
FROM movie
WHERE 10>id | ||
| MySQL | ||
| The SQL Standard is the CASE statement | ||
| Specific to MySQL | ||
The IF function is also available:
SELECT title,
score,
IF(score>8.5,'Excellent','OK')
FROM movie
WHERE 10>id | ||