I tried to update a particular record with same value again and again, but it returns the affected rows value as 1 always.

```
update users set active = 1 where id = 304
1 row(s) affected.

```

again the same query 

```
update users set active = 1 where id = 304
1 row(s) affected.

```

but the second update should return 0 row(s) affected right? May I know how can I get zero count while its not updating the record originally.