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