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. Quote 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. Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.