Stephen68 Posted November 24, 2007 Share Posted November 24, 2007 I have a DB that has a ENUM set to true,false, what I was wondering if there was a way to set all records in the database to false that are of a certain type. I could count the entries and then fun a loop or something I guess but I thought maybe there was a better way. Here is more of what I mean I have a table with a field "Type" and "Display", display being the ENUM field. What I'm looking for is to set all the records of type "X-type" to false. Any help would be great. Stephen Quote Link to comment https://forums.phpfreaks.com/topic/78704-solved-mysql-query-help/ Share on other sites More sharing options...
Barand Posted November 24, 2007 Share Posted November 24, 2007 UPDATE tablename SET Display='false' WHERE Type = 'X-type' Quote Link to comment https://forums.phpfreaks.com/topic/78704-solved-mysql-query-help/#findComment-398371 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.