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... Link to comment https://forums.phpfreaks.com/topic/118571-solved-very-simple-alter-question/ 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' Link to comment https://forums.phpfreaks.com/topic/118571-solved-very-simple-alter-question/#findComment-610471 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... Link to comment https://forums.phpfreaks.com/topic/118571-solved-very-simple-alter-question/#findComment-610472 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.