[RESOLVED] Escaping Brackets ()

[obrienkev]

Hi all,

How do I escape brackets () when inserting data into mysql table?

e.g. insert into tbl values("Check (Checksheet)", "test");

Thanks.

[laserlight]

You should not need to escape parentheses in the first place.

[obrienkev]

Why do I get this error...

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(Accountants Checksheet), 2001-05-24,

[laserlight]

Probably has to do with say, incorrect quoting of input strings. I advise using single quotes instead of double quotes for SQL strings.