How to properly escape a column name?

Hi all,
The question is how to escape the column name in the query directly?
Here is a simple example, the name of the column corresponds to the update statement:
update stats set update='100', pdef='100', mdef='100' where id='500';
April 3rd 20 at 17:45
1 answer
April 3rd 20 at 17:47
Solution
update `stats` set `update`='100', `pdef`='100', `mdef`='100' where `id`='500';

Find more questions by tags MySQLSQL