Re: MySQL: Return Number of Matched Rows
| From: | Floyd Resler | Date: | Thu, 25 Mar 2010 21:16:39 +0000 |
| Subject: | Re: MySQL: Return Number of Matched Rows | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-303477@lists.php.net to get a copy of this message | ||
On Mar 25, 2010, at 5:10 PM, James Colannino wrote:
> 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
>
As for as I know, MySQL simply just doesn't report a row as being affected if nothing has
changed in it. To get the number of matched rows, try doing a SELECT query before you do the UPDATE
query. I don't know if that will produce the results you're looking for, but it might.
Take care,
Floyd