MySQL: Return Number of Matched Rows
| From: | James Colannino | Date: | Thu, 25 Mar 2010 21:10:16 +0000 |
| Subject: | MySQL: Return Number of Matched Rows | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-303476@lists.php.net to get a copy of this message | ||
Hey everyone,
I have a question. If I do a mysql query that updates a column in a row
to the same value, I get 0 rows affected. However, I also get 1 or more
matched rows. Is there a way that I can return the number of matched
rows, rather than the number of rows affected?
I'm trying to get something done with as few SQL queries as possible.
Thanks!
James