Thanks to everyone for being so helpful with this solution. Douglas
-- Douglas R. Brantz Computer Consultant Fine & Applied Arts Appalachian State University Boone, NC 28608 828-262-6549 (office) 828-262-6312 (fax) -----Original Message----- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 3:46 PM To: Douglas Brantz; [EMAIL PROTECTED] Subject: RE: Pattern Matching Problem SELECT schdays FROM courses WHERE (schdays LIKE "M") OR (schdays LIKE "W") OR (schdays LIKE "F") Matthew Walker Ecommerce Project Manager Mountain Top Herbs -----Original Message----- From: Douglas Brantz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 1:15 PM To: [EMAIL PROTECTED] Subject: Pattern Matching Problem 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 entri es 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%" H ere 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 82 8-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 --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.317 / Virus Database: 176 - Release Date: 1/21/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.317 / Virus Database: 176 - Release Date: 1/21/2002 --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
