Try this:
select schdays from courses where schdays Regexp"[MWF]";
-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 patter
In the last episode (Jan 29), Douglas Brantz said:
> 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
chdays 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 PROTECT
At 14:59 -0500 1/29/02, Douglas Brantz wrote:
>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.
It's unclear what you're expecting to happen. From th
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
