MYSQL insert 单引号问题
我想把sql语句作为个字段存储在mysql 数据库中,可是insert 的时候出现问题
select * from person where person_jobwill in("互联网开发及应用"), person_jobarea in(''青海-''), order by person_id descYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'sql,company_id)values('网络编程',''select * from person where person_jobwill in(' at line 1
其实就是在 in ('','') 的时候出错
因为我的sql字段是varchar 类型,所以
我的语句这样写 "insert into company_search(sql)values('".$sql."')"
请问这个问题应该怎样解决呢