Paul DuBois writes:
>At 12:50 -0800 2/7/02, Cindy wrote:
>>"Rutledge, Aaron" writes:
>> >MySQL doesn't support LIKE does it? I got an error when I tried.
>>
>>I use it all the time. Maybe post the error message you got.
>>
>>RLIKE on the other hand
>
>sigh, what? RLIKE works. I
--Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 1:12 PM
To: Rutledge, Aaron
Cc: Mysql List (E-mail)
Subject: Re: LIKE work around??
Work-around? LIKE should work just fine...
mysql> select * from fruits where fruit_name like '%banana%
At 12:50 -0800 2/7/02, Cindy wrote:
>"Rutledge, Aaron" writes:
> >MySQL doesn't support LIKE does it? I got an error when I tried.
>
>I use it all the time. Maybe post the error message you got.
>
>RLIKE on the other hand
sigh, what? RLIKE works. It's the same as REGEXP.
>
>--Cindy
-
You don't want to use LIKE in mysql - or have you not read about LIKE in
the fine mysql manual??
If you use LIKE you will also need to use a % sign signify which bit is the
variable bit. This is because mysql allows you to say if the variable bit
is at the start or the end or both. LIKE 'ban
> input is >SELECT dog_name FROM hold_tbl WHERE dog_name RLIKE "^sam[0123456789]*"
> ORDER BY dog_name<
>
> (and then printing out each of the matches made)
> Sam
> Sam4
> Sam5
> Sammie6
> Sammy7
> Sampson2
> Samson
> Samuel
>
> As I understand it, only the first three should have match
Umm, I take it you haven't read the documentation? MySQL fully supports
LIKE. Can you tell us the error you are getting? Along with the full query?
j- k-
On Thursday 07 February 2002 11:11, Rutledge, Aaron wrote:
> MySQL doesn't support LIKE does it? I got an error when I tried.
--
"Rutledge, Aaron" writes:
>MySQL doesn't support LIKE does it? I got an error when I tried.
I use it all the time. Maybe post the error message you got.
RLIKE on the other hand
--Cindy
-
Before posting, please check:
MySQL doesn't support LIKE does it? I got an error when I tried. =20
-Original Message-
From: Nathan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 1:04 PM
To: Rutledge, Aaron
Subject: Re: LIKE work around??
Um... keep using LIKE? Just a thought... :-)
- Ori
I am trying to query the database for records that have the same
sequence of starting characters--such as banana1 and banana2 and have a
result set returned that contains everything that starts with banana.
Any way to do this? I think I would use LIKE in other types of
databases, but I was wonder
Work-around? LIKE should work just fine...
mysql> select * from fruits where fruit_name like '%banana%';
On Thu, 7 Feb 2002, Rutledge, Aaron wrote:
> I am trying to query the database for records that have the same
> sequence of starting characters--such as banana1 and banana2 and have a
> re
> input is >SELECT dog_name FROM hold_tbl WHERE dog_name RLIKE "^sam[0123456789]*"
> ORDER BY dog_name<
>
> (and then printing out each of the matches made)
> Sam
> Sam4
> Sam5
> Sammie6
> Sammy7
> Sampson2
> Samson
> Samuel
>
> As I understand it, only the first three should have match
Paul DuBois writes:
>At 12:50 -0800 2/7/02, Cindy wrote:
>>"Rutledge, Aaron" writes:
>> >MySQL doesn't support LIKE does it? I got an error when I tried.
>>
>>I use it all the time. Maybe post the error message you got.
>>
>>RLIKE on the other hand
>
>sigh, what? RLIKE works. I
At 12:50 -0800 2/7/02, Cindy wrote:
>"Rutledge, Aaron" writes:
> >MySQL doesn't support LIKE does it? I got an error when I tried.
>
>I use it all the time. Maybe post the error message you got.
>
>RLIKE on the other hand
sigh, what? RLIKE works. It's the same as REGEXP.
>
>--Cindy
-
"Rutledge, Aaron" writes:
>MySQL doesn't support LIKE does it? I got an error when I tried.
I use it all the time. Maybe post the error message you got.
RLIKE on the other hand
--Cindy
-
Before posting, please check:
Umm, I take it you haven't read the documentation? MySQL fully supports
LIKE. Can you tell us the error you are getting? Along with the full query?
j- k-
On Thursday 07 February 2002 11:11, Rutledge, Aaron wrote:
> MySQL doesn't support LIKE does it? I got an error when I tried.
--
al Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 1:12 PM
To: Rutledge, Aaron
Cc: Mysql List (E-mail)
Subject: Re: LIKE work around??
Work-around? LIKE should work just fine...
mysql> select * from fruits where fruit_name like '%banana%
Work-around? LIKE should work just fine...
mysql> select * from fruits where fruit_name like '%banana%';
On Thu, 7 Feb 2002, Rutledge, Aaron wrote:
> I am trying to query the database for records that have the same
> sequence of starting characters--such as banana1 and banana2 and have a
> re
MySQL doesn't support LIKE does it? I got an error when I tried.
-Original Message-
From: Nathan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 1:04 PM
To: Rutledge, Aaron
Subject: Re: LIKE work around??
Um... keep using LIKE? Just a thought... :-)
- Ori
SELECT * FROM Table WHERE Fruit LIKE "banana%"
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Rutledge, Aaron [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 12:56 PM
To: Mysql List (E-mail)
Subject: LIKE work around??
I am
On Thursday 07 February 2002 12:56 pm, Rutledge, Aaron wrote:
> I am trying to query the database for records that have the same
> sequence of starting characters--such as banana1 and banana2 and have a
> result set returned that contains everything that starts with banana.
> Any way to do this?
I am trying to query the database for records that have the same
sequence of starting characters--such as banana1 and banana2 and have a
result set returned that contains everything that starts with banana.
Any way to do this? I think I would use LIKE in other types of
databases, but I was wonder
21 matches
Mail list logo