DBookatay Posted August 7, 2008 Share Posted August 7, 2008 Using PHPMyAdmin, what is the SQL query to alter all the items in the "body" cell from "SUV" to "Sport Utility"? Its been a while since I've used MySQL and this has completely slipped my mind... Quote Link to comment Share on other sites More sharing options...
abdfahim Posted August 7, 2008 Share Posted August 7, 2008 UPDATE `your_table` SET `body`='Sport Utility' WHERE `body`='SUV' Quote Link to comment Share on other sites More sharing options...
DBookatay Posted August 7, 2008 Author Share Posted August 7, 2008 UPDATE `your_table` SET `body`='Sport Utility' WHERE `body`='SUV' Thank you, this is what I needed... 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.