如何更改我正在检索的记录的状态

Question

i want to change the status of the message which i am retrieving. consider a MySQL database with three column message,username and status.

from this table i am retrieving the message which are all having the status 1. for example i am retrieving the message of user1 which status is 1 after retrieving that message i want to change the status of that message to 0. only the user1 message status not the others. How do i do it? Someone please answer.....

Answer 1

Just use UPDATE statement

UPDATE message_user2 
SET status = 0 
WHERE Username = 'user1'