xxxxxxxxxx
SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(ColumnA, 'Country=', -1), '&', 1) AS ColumnB
FROM `atable`
xxxxxxxxxx
LOCATE() function in MySQL is used for finding the location of a substring in a string. It will return the location of the first occurrence of the substring in the string. If the substring is not present in the string then it will return 0.
xxxxxxxxxx
SELECT SUBSTRING(ColumnName, POSITION('CharacterToFind',ColumnName)) FROM schema.TableName