I have a table ,for example,
Id first_name gender
1 Alexis Female
2 Luke Male
3 Jireh Male
4 Luke Male
UPDATE members SET first_name='Eduard' WHERE first_name='Luke'
UPDATE on the Id column rather than on
FirstName in the
WHERE clause. As shown below.
UPDATE members SET first_name = 'Eduard' WHERE Id = 2
The benefits of doing it by ID is that you know the exact row you are updating rather than assuming the
member you are attempting to update is the correct one.