How to do you Use a substring()

SQL Tutorial Home

This classic string function has two different names in MySQL.

select substring('hello how are you', 7, 3) as substring, 
       	 substr('hello how are you', 7, 3) as substr
substring substr
“how” “how”

The second parameter specifies the position where the substring starts and the third parameter is the length of the substring to extract.

IN THIS PAGE