Tagged Questions
6
votes
1answer
1k views
Why would an UPDATE SET REPLACE() statement match rows, but change none and give no warnings?
I'm seeking a certain string in a field and want to replace it with a new string. Specifically, I want all references to one URL to be changed to another URL. I've crafted this SQL statement and am ...
2
votes
1answer
258 views
MySQL Update: why would rows matched change based on the set clause?
I ran an update query joining across a huge number of tables that updated one field, and it matched 29k some-odd rows. Running the same query with only an addition in the Set clause increased the ...
