Replace char in column

Question

I'm trying to delete the char . from a column in a table.

Column = n_license table = fighters_fighter

Query I'm trying to use:

UPDATE `fighters_fighter` SET `n_license` = REPLACE (`n_license`,`.`,``);

Error:

1054 - Unknown column '.' in 'field list'

Which could be the problem?

Answer 1

Wrong quotes on the characters.

UPDATE fighters_fighter 
SET n_license = REPLACE (n_license,'.','');

Answer 2

The char should be enclosed within '' not the ``

UPDATE `fighters_fighter` 
SET `n_license` = REPLACE (`n_license`,'.','');