url存入mysql数据库前的时候要进行什么处理？

SQL code:
UPDATE `footballmatch`.`promote` SET `pr_ballhype` = http://ballhype.com/post/url/?url=http%3A//www.allfootballtv.com/%3Fp%3D369&league=8 WHERE `promote`.`fm_post_id` =369


以上sql语句存入mysql中的时候提示错误：
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 '://ballhype.com/post/url/?url=http%3A//www.allfootballtv.com/%3Fp%3D369&league=8' at line 2


pr_ballhype 字段类型为varchar

请问该如何修改呢？

---

varchar型看看字符是否足够用。
UPDATE `footballmatch`.`promote` SET `pr_ballhype` = 'http://ballhype.com/post/url/?url=http%3A//www.allfootballtv.com/%3Fp%3D369&league=8'  WHERE `promote`.`fm_post_id` =369 //分号少不了！

---

htmlspecialchars(),

---

引用

varchar型看看字符是否足够用。
UPDATE `footballmatch`.`promote` SET `pr_ballhype` ='http://ballhype.com/post/url/?url=http%3A//www.allfootballtv.com/%3Fp%3D369&league=8'  WHERE `promote`.`fm_post_id` =369 //分号少不了！

确实是加个引号就行了，谢谢了