How to get the exact string within the brackets in mysql
Posted
by
sreenath
on Stack Overflow
See other posts from Stack Overflow
or by sreenath
Published on 2013-11-07T08:39:21Z
Indexed on
2013/11/07
9:54 UTC
Read the original article
Hit count: 190
mysql
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.
© Stack Overflow or respective owner