请问下是什么引起的错误

[cherry_hit_tom]

2014/04/25 10:43:29 MySQL 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 'pjx%&'' at line 1 select id from users where user_id=' 上海的天~pjx%&'

[benluobo]

贴出你的SQL语句

[cherry_hit_tom]

select id from users where user_id=' 上海的天~pjx%&'

[benluobo]

select id from users where user_id=' 上海的天~pjx%&' 测试没问题

[ACMAIN_CHM]

最好在命令行工具直接执行以判断到底是否有错误。