MENU
Type Conversion
| The type for a CONVERT(expr, type) and CAST(expr AS type) can be BINARY [(N)], CHAR[(N)], DATE. DATETIME, DECIMAL [(M [,D])], TIME, UNSIGNED [INTEGER]. | |
| SELECT 2 + '2'; | 4 |
| SELECT CONCAT(2, '2'); | 22 |
| SELECT CONVERT(2, CHAR) + CAST(2 AS UNSIGNED INT); |
4 |
| SELECT 1 > NULL; | NULL |
| SELECT 1 = 0x01, '1' = 0x01; | 1 0 |
| SELECT 2 > '5x', 0 = 'x5'; | 0 1 |
| SELECT 'a' = 'A', BINARY 'a' = 'A'; | 1 0 |
| SELECT CONVERT('xyz' USING 'utf8'); | xyz |