Hello, I have a big problem! I need to match all patterns in schdays from a variable schdays and if schdays = mwf it only turns up mwf and not all entries containing M, W or F. Is there a way to do this?
mysql> select schdays from courses where schdays LIKE "%MWF%"; +---------+ | schdays | +---------+ | MWF | +---------+ 1 row in set (0.00 sec) mysql> select schdays from courses where schdays LIKE "%M%"; +---------+ | schdays | +---------+ | MWF | | MW | | MW | | M | | M | +---------+ 5 rows in set (0.00 sec) I need to be able to say select schdays from courses where schdays LIKE "%schdays%" Here is my code from the program: my $sth2 = $dbh->prepare("select id,schdays,time_to_sec(timein),time_to_sec(time out) from courses where schdays LIKE \"\%$cschdays\%\" AND done=\"Yes\"....etc.. So I need to be able to match any pattern with $cschdays. Do I need to parse out the letters and pattern match each one?? It should be easier. Thanks, Douglas [EMAIL PROTECTED] -- Douglas R. Brantz Computer Consultant Fine & Applied Arts Appalachian State University Boone, NC 28608 828-262-6549 (office) 828-262-6312 (fax) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php