dimanche 26 juin 2016

Use update statement in where clause

Is it possible to use an UPDATE statement within the WHERE clause of a SELECT statement?

I would like to execute something like this but it doesn't work:

SELECT * FROM table1 WHERE col1 < (UPDATE table1 SET col2='test' WHERE id=1)

I use mysql_query in PHP.

Aucun commentaire:

Enregistrer un commentaire