How to substring in mysql

How to use substring a MySQL table column.

Example:

select 'testing' 

Answer

MySQL SUBSTR(),SUBSTRING() returns the specified number of characters from a particular position.

str - A string.
pos - Starting position.
len - Length in characters.

Syntax:

SUBSTR(str, pos, len)

OR 

SUBSTRING(str, pos, len)

 Select Query:

select 'testing'

Result:

SubString:

SELECT SUBSTR('testing', 2, 3)

Result: