I just figured out the result of a MySQL query between updating no matched records and updating a matched record that already has the values has no differences?
I have a query like this:
UPDATE uri SET is_active = 1 WHERE f_site_id = '73' AND language_code = 'NL' AND additional = 'item' AND is_forwarder = '0'
If I run this query and there are matched records, but their data does not change, I get a result of 0 rows affected? If I don't have any records with the above WHERE selection, MySQL returns 0 affected records....
I need to know after the update if there are matched records or not. It doesn't really matter if the data in the record is already the same, but I need to know that there are matched records.
How do I achieve this?