BWSnippet

Mysql select sub-string from database

Mysql select sub-string from database

Select part of a string from a field in the database using mysql

SELECT 
 SUBSTRING(  field , 11 , 3 )
 as alias  FROM  table WHERE some_field=1111 

Tags

Mysql select sub-string from database