Overview
In this tutorial, we will learn about MySQL LEFT function with an example. The function returns the leftmost length of characters from the string.
Syntax
The general syntax of the function is as follows:
LEFT(string,length)
Example
mysql> SELECT LEFT(‘TestingDocs’,4);
+———————–+
| LEFT(‘TestingDocs’,4) |
+———————–+
| Test |
+———————–+
1 row in set (0.00 sec)
mysql> SELECT LEFT(NULL,4);
+—————————-+
| LEFT(NULL,4) |
+—————————-+
| NULL |
+—————————-+
1 row in set (0.00 sec)
—
MySQL Tutorials
MySQL Tutorials on this website:
https://www.testingdocs.com/mysql-tutorials-for-beginners/
For more information on MySQL Database: