Strange database issue when WHERE contains brackets

[eluser]LinkFox[/eluser]
Hello,

Getting a very strange issue where I am querying against a database for a name for the ID.

The query is something like this. (removed table names for security reasons)

SELECT xx_id FROM (xx s) JOIN ss b ON b.xx_id = s.xx_id WHERE s.deleted !=1 AND s.xx_id =100 AND s.aaa ='xxx (xxxxx)'

When the s.aaa contains ( ) the query through CI will return an empty result set.

When I dump the query using last_query() and run that query in phpmyadmin I get the correct ID back...does anyone know how to get around this? or what the issue could be.

Thanks in advance.