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: 191

Filed under:

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

Related posts about mysql