Answers for "mysql substring"

SQL
4

mysql get first x characters

SELECT LEFT(title , 10) FROM articles;
Posted by: Guest on May-01-2020
0

get substring from a string in mySql

mysql> SELECT SUBSTRING('w3resource',4,3);
+-----------------------------+
| SUBSTRING('w3resource',4,3) |
+-----------------------------+
| eso                         | 
+-----------------------------+
1 row in set (0.00 sec)
Posted by: Guest on May-05-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language