Solution to Mysql database update errors

Statement:

UPDATE test SET age = 5 WHERE 'name' = 'wang taobao'

As the name implies, Wang's age is changed to 5, but the result is helpless --

The number of affected rows is 0. What's going on? The syntax is correct. It's okay ......

I changed it and removed the two quotation marks of the name, but the result was accidentally succeeded --

However, the results are even more confusing when you change the GUI --

The generated code is --

UPDATE 'web'. 'test' SET 'age' = '20' WHERE 'test'. 'name' = 'wang man' LIMIT 1;

Puzzling ......

Through comparison, we found that the single quotes I wrote are different from the generated single quotes, and they are even more confused ......

Which of the following is perfect ???