jck Posted July 12, 2007 Share Posted July 12, 2007 replace the value of a particular field in a particular table with a new one Quote Link to comment Share on other sites More sharing options...
cmgmyr Posted July 12, 2007 Share Posted July 12, 2007 "UPDATE table SET column = new_value WHERE column = old_value" something like that? Quote Link to comment Share on other sites More sharing options...
per1os Posted July 12, 2007 Share Posted July 12, 2007 Umm yea, very descriptive. Write the question better and more thorough than you might get some help. Quote Link to comment Share on other sites More sharing options...
jck Posted July 12, 2007 Author Share Posted July 12, 2007 theres no need to put WHERE column = old_value" or is there?? Quote Link to comment Share on other sites More sharing options...
cmgmyr Posted July 12, 2007 Share Posted July 12, 2007 if you want to change all of the rows to the new_value...no, but if you just want to change a certain old_value...yes Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.