select - How to fetch mysql data having brackets? -

i want fetch mysql data having round brackets e.g. abcd(xyz). when run query

"select * tablename column = 'abcd(xyz)'"

it returns empty result. please suggest way. in advance!

this should work:

insert `tablename` (`column`) values ('abcd(xyz)');  select * `tablename` `column` = 'abcd(xyz)'";

maybe 'abcd(xyz)' not value of data (for example if inserted whitespaces before or after it.) can try find out:

select * `tablename` `column` '%abcd(xyz)%'";

another possibility value has been converted htmlentities , saved this:

'abcd&40;xyz&41;'

&40; left parenthesis

&41; right parenthesis

Live