[SOLVED] how find value from mysql array record

[stav]

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.

[kickstart]

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

[stav]

Thank you !!