sql get first 10 characters code example
Example 1: mysql get first x characters
SELECT LEFT(title , 10) FROM articles;
Example 2: sql left characters
-- For Oracle only
-- syntax
SUBSTR(<main-string>,1,<number-of-characters>)
-- example
SUBSTR('Useless stuff',1,10) -- OUTPUT: Useless st
-- practical example
SELECT SUBSTR('Useless stuff',1,10)
FROM DUAL;