[UKSBD]

Does anyone know how to add coding as a default value in a MySQL field?

I am trying to set a default value of an existing field, but the default value
I want to add is coding that includes * "" and !

I am using,
UPDATE `tbl_test` SET `newfield` = 'default value'

it works fine if the default value is plain text, but if I try to add the coding
as the default value, the last quotation mark gets removed resulting in an error.

Any help appreciated.

Just to add.
The site is in .ASP (php enabled) and I am trying to do it via phpmyadmin