LEFT(str,len): Returns the leftmost len characters from the string str, or NULL if any argument is NULL : LEFT « String Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. String Functions
  3. LEFT
mysql>
mysql> SELECT LEFT('ABCDEFG', 3);
+--------------------+
| LEFT('ABCDEFG', 3) |
+--------------------+
| ABC                |
+--------------------+
1 row in set (0.00 sec)

mysql>








23.19.LEFT
23.19.1.LEFT(str,len): Returns the leftmost len characters from the string str, or NULL if any argument is NULL
23.19.2.Use LEFT with data in a table