ssion matching on each row? You could add two more columns, days_mwf
and days_th, to speed up the common queries.
Bret
-Original Message-
From: Matthew Walker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 29, 2002 3:46 PM
To: Douglas Brantz; [EMAIL PROTECTED]
Subject: RE: Pattern Mat
CTED]]
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
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]
At 15:15 -0500 1/29/02, Douglas Brantz wrote:
>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?
Yes, but you can't do it with LIKE excep
At 03:15 PM 1/29/2002 -0500, Douglas Brantz wrote:
>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 course
