How to get the exact string within the brackets in mysql
- by sreenath
In my mysql table a field values are as follows:
table name - "clients"
field name - "accent"
values are - "Eastern(Northern,Southern),Scottish(East Coast)"
"Eastern(South,North,Southern),Scottish(East Coast)"
If I give
select accent from clients where accent like '%north%'
if more than 100 records not in the same order. Strings with in the brackets are not in the same order means.
It will give above two values.
How should i get only second value?
Please help me, thanks.