lundi 29 août 2016

select with update in one query

I have a query like:

SELECT id, name, surname, fromId, toId, msg_text, readed FROM messages WHERE toId = 2;

So I want to update all selected rows.readed = 1. And Query must return all selected rows.

These action must do in one query if possibe.

Sorry for my english

Aucun commentaire:

Enregistrer un commentaire