How to change the values ​​of only one line in the database?

Question

MySQL

Hello, there is a table in which there are rows with a unique id and data that need to be changed (likes_count)

To change the data, I used the following query:

SELECT id FROM `users` WHERE `id` = '$rows ['id']'; UPDATE `users` SET `likes_count`= '2' WHERE 1

But it changes the data for all rows, and not for the id obtained from the rows array. With my efforts, I came to the conclusion that I need to write another request, but I just can’t figure out how to compose it ..

Answer 1

UPDATE `users` SET ``likes_count` = "Value to change to" WHERE `id` = id to change to