I have a field in a table in an mysql database which has been named My Project. I would like to know how to update that field as I get an error message because of the space between My and Project.
set My Project=23
I have tried single quotes, square brackets, hash marks etc but have had no luck. I cannot change the field name at this point.
Can anyone help, please