adding in SQL text with apostrophes

[infinitium]

hey guys...

slight dilemma.

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

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....

[oblig]

Backspace before the apostrophe?

Like:

SET text='infinitium[b]\[/b]'s a cool guy' WHERE ID=10662105; 

[alexk]

you should use backslashes:

SET text='infinitium\'s a fn\' cool guy' WHERE ID=10662105;

[infinitium]

just what i was looking for.. thanks!