Re: MySQL: Return Number of Matched Rows

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 If it works in your situation you can use REPLACE instead of UPDATE and the mysql_affected_rows() should work. You may need to divide this number by 2 as I think it counts the deletes and inserts. -- Thanks! -Shawn http://www.spidean.com