Time : 02:57:33 SQLSTATE[42000]: Syntax error or access violation: 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 '\'A=0' at line 4 Raw SQL : SELECT *, b.code, b.category_name as `name`, c.code as code1, c.category_name as cate FROM totalweb_brand a LEFT OUTER JOIN totalweb_category b ON a.category = b.code LEFT OUTER JOIN totalweb_category c ON CONCAT(SUBSTR(a.brandcode, 1, 6),'000000') = c.code WHERE CONCAT(SUBSTR(brandcode, 1, 6),'000000')=002005000000\'A=0 Time : 02:57:33 SQLSTATE[42000]: Syntax error or access violation: 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 '\'A=0' at line 1 Raw SQL : SELECT count(*) FROM totalweb_brand where CONCAT(SUBSTR(brandcode, 1, 6),'000000')=002005000000\'A=0 Time : 02:57:33 SQLSTATE[42000]: Syntax error or access violation: 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 '\'A=0 ORDER BY brandcode' at line 1 Raw SQL : SELECT * FROM totalweb_brand where CONCAT(SUBSTR(brandcode, 1, 6),'000000')=002005000000\'A=0 ORDER BY brandcode