Paul Dubois helped me on this: Check page 520 of his book. REGEXP "[MWF]" matches all I need everything inside the [...] (brackets).
Thank you again Paul. That problem fixed now moving on to the next one. 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: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 3:24 PM To: Douglas Brantz; [EMAIL PROTECTED] Subject: RE: Please Help with Pattern Matching Doug, MySql is doing what it is supposed to... If you specify '%MWF%' it will only select the values with the string literal 'MWF' in it. If you would like to match all the rows that have either M or W or F in it, then use a query like : select schdays from courses where schdays LIKE "%M%" OR LIKE "%W%" OR LIKE "%F%"; This will return every row that has either M or W or F in the schdays field. Gurhan -----Original Message----- From: Douglas Brantz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 2:59 PM To: [EMAIL PROTECTED] Subject: Please Help with Pattern Matching 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 --------------------------------------------------------------------- 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
