Updating specific values in a column
I have a content management system that allows me to add/edit/delete entries in our site's database. I'm trying to update a column in a table that has different values. One of the values is "Unknown." and I'm trying to replace all instances with "Not available." Here's the code:
Simple, right? It does work - the changes show up when I view the entries in the DB; however, when I go visit one of the entries to see if the changes were made, I still see "Unknown." in the req field. In other words, the site does not display the change.
SET req = "Not available."
WHERE req = "Unknown.";
Any idea why this is happening? I do not want to manually go through each entry with the unknown value, as there are over 1000 such entries.
What DBMS are you using? Does it require a COMMIT in order to, well, commit transactions?
MySQL 5.1, and autocommit is enabled. I even cleared by browser cache, as well as used different browsers.
Originally Posted by NogDog
Someone suggested I clear the query cache, but that didn't work either.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)