chmpdog Posted June 1, 2010 Share Posted June 1, 2010 Currently my database I have settings values in a single row. IE: the row is settings and the value is "0,0,0" Then I would use the explode function to find if a value is false or true. Is there a way to select all the rows in the database where the second value is true regardless of what the other values are? IE: "0,1,0" "1,1,1" "1,1,0" ect. Link to comment https://forums.phpfreaks.com/topic/203561-database-info-w-explode-function/ Share on other sites More sharing options...
premiso Posted June 1, 2010 Share Posted June 1, 2010 SELECT * FROM table_name WHERE column_name LIKE '%,1,%' Should do that for you. Link to comment https://forums.phpfreaks.com/topic/203561-database-info-w-explode-function/#findComment-1066302 Share on other sites More sharing options...
chmpdog Posted June 1, 2010 Author Share Posted June 1, 2010 gracias Link to comment https://forums.phpfreaks.com/topic/203561-database-info-w-explode-function/#findComment-1066347 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.