mysqli =substring(@ first 4 characters left code example

Example: mysql get first x characters

SELECT LEFT(title , 10) FROM articles;