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 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' Link to comment https://forums.phpfreaks.com/topic/78704-solved-mysql-query-help/#findComment-398371 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.