I have a big problem with pattern matching; Why does the first example work like this I need to find everything with MWF in it and I only get the 1 entry? Is there a way I can make this work.
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) Thanks in advance, Douglas -- 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