stav Posted November 18, 2009 Share Posted November 18, 2009 I have MySql db_table with column 'days_in_week' with values like record_id1 = weekly|99|MO|TU|WE|TH|FR record_id2 = weekly|99|TU|TH|FR record_id3 = weekly|99|MO|WE record_id4 = weekly|99|SA etc.. How can i find which record has e.g. WE in the array separated by |. e.g. $Today = substr(strtoupper(date('l')),0,2); //$Today='WE'; I was trying REGEXPthis but i have one wrong result back. $mysql_Query = "SELECT from db_table where days_in_week REGEXP '".$Today."' "; How can i do that something like PHP in_array() function. Thanks. Quote Link to comment Share on other sites More sharing options...
kickstart Posted November 18, 2009 Share Posted November 18, 2009 Hi Just use LIKE. $mysql_Query = "SELECT from db_table where days_in_week LIKE '%|".$Today."%' "; However it would probably be a better idea to split the data off as rows on a seperate table, so you can just look for a row on one table with a related row on the other for the day you are interested in. All the best Keith Quote Link to comment Share on other sites More sharing options...
stav Posted November 18, 2009 Author Share Posted November 18, 2009 Thank you !! Quote Link to comment 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.