mysql - Parentheses become encoded in codeigniter db query -

I have a legacy database that contains some brackets, such as "red (b)".

But if I try to query for that value, the brackets are encoded.

This query:

 select  from the table where the field 1 = "red (b)"  

creates this query:

  Select * From the table where the field 1 = "Red & amp; # 40; B & # 41;"  

(I & amp; # I place a space in between so that it can be shown).

This will not return any rows.

How to manage this?

Have you tried to avoid the query? I.e.

  Select from the table where the field 1 = "red \ (b) \"