hey guys...

slight dilemma.

I'm using mySQL and am inserting / updating stuff into a table like this:

PHP Code:
update pdc_emp
SET text
='infinitium is a cool guy' WHERE ID=10662105
Ok... now how do I modify it so SQL will recognize the text "'infinitium's a cool guy", with the apostrophe?

this is just an example.. don't mind the actual inserted text....