Hi, Michael!
> Really? In 4.0? In which character set is '' equivalent to '%' to LIKE?
Thank you for the advertence, I was just going to figure it out:)
You are right, I haven't should asked to show me the collation.
Still I'd like to the see the value of character_set system variable.
[EMAIL PROTECTED] wrote:
> Hi all,
>
> I've got a question. We were testing something on our mysql server (
> 4.0.21) with MyISAM tables.
>
> When we executed the query "select * from people where name like '';" we
> expected the same results as "select * from people where name='';" but it
> didn'
Hello.
I was unable to repeat this situation on my MySQL 5.0.12. See:
mysql> create table tlike (a char(10));
Query OK, 0 rows affected (0.01 sec)
mysql> insert into tlike values('abc');
Query OK, 1 row affected (0.02 sec)
mysql> select * from tlike where a like '';
Empty set (0.00 s
PROTECTED]>
Cc:
Sent: Sunday, September 11, 2005 16:18 PM
Subject: Re: Behaviour of like expression
> [EMAIL PROTECTED] wrote:
> > Hi all,
> >
> > I've got a question. We were testing something on our mysql server (
> > 4.0.21) with MyISAM tables.
> >
> &
[EMAIL PROTECTED] wrote:
Hi all,
I've got a question. We were testing something on our mysql server (
4.0.21) with MyISAM tables.
When we executed the query "select * from people where name like '';" we
expected the same results as "select * from people where name='';" but it
didn't.
The l
