xxxxxxxxxx
SELECT SUBSTRING(ColumnName, POSITION('CharacterToFind',ColumnName)) FROM schema.TableName
xxxxxxxxxx
mysql> SELECT SUBSTRING('Quadratically',5);
-> 'ratically'
mysql> SELECT SUBSTRING('Quadratically',1,4);
-> 'Quad'
mysql> SELECT SUBSTRING('foobarbar' FROM 4);
-> 'barbar'
mysql> SELECT SUBSTRING('Quadratically',5,6);
-> 'ratica'
mysql> SELECT SUBSTRING('Sakila', -3);
-> 'ila'
mysql> SELECT SUBSTRING('Sakila', -5, 3);
-> 'aki'
mysql> SELECT SUBSTRING('Sakila' FROM -4 FOR 2);
-> 'ki'
xxxxxxxxxx
SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(ColumnA, 'Country=', -1), '&', 1) AS ColumnB
FROM `atable`
xxxxxxxxxx
SELECT SUBSTRING(column_name, start_position, end_position)
FROM table_name;