MySQL easy syntax question

[Socks]

update category_text set text='this is a problem because it's got an apostrophe in it', keywords='asdf,asdf' where id='1';

Just that the string I want to insert has an apostrophe.. Is that going to mess the syntax up?

[jMEGA]

try this

update category_text set text='this is a problem because it\'s got an apostrophe in it', keywords='asdf,asdf' where id='1';

[Socks]

Nice thanks!! Now I know why I've seen those things printed around my site sometimes heh

[V_RocKs]

google for php html entities

[nation-x]

if this is for a php script then you can just use http://us3.php.net/mysql_real_escape_string

$sql = "update category_text set text='".mysql_real_escape_string("this is a problem because it's got an apostrophe in it")."', keywords='asdf,asdf' where id='1';"

$affected_rows = mysql_query($sql);