List: General Discussion « Previous MessageNext Message » From: Douglas Brantz Date: January 29 2002 9:00pm Subject: RE: Pattern Matching Problem Solved View as plain text
```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:mwalker@stripped]
Sent: Tuesday, January 29, 2002 3:46 PM
To: Douglas Brantz; mysql@stripped
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:brantzdr@stripped]
Sent: Tuesday, January 29, 2002 1:15 PM
To: mysql@stripped
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
brantzdr@stripped

--
Douglas R. Brantz
Computer Consultant
Fine & Applied Arts
Appalachian State University
Boone, NC 28608

82
8-262-6549 (office)
828-262-6312 (fax)

---------------------------------------------------------------------
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/           (the list archive)

To unsubscribe, e-mail
<mysql-unsubscribe-matt=mountaintopherbs.com@stripped>
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

---------------------------------------------------------------------
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com
/           (the list archive)

To unsubscribe, e-mail
<mysql-unsubscribe-brantzdr=appstate.edu@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

```