Problem with like wildcard syntax

[Matt Mastrangelo]

I'm running version 4.1.1-alpha. The 3 select statements below on the 
following test table produce inconsitent results:

create table test (test varchar(20)) charset latin1 collate 
latin1_general_cs;
insert into test values ('abcField1');
insert into test values ('abcField2');
insert into test values ('abcField3');
insert into test values ('xyzField1');
insert into test values ('xyzField2');
insert into test values ('xyzField3');

select * from test where test like '___Field%'; /* Works */
select * from test where test like '%Fie%'; /* Works */
select * from test where test like '%Field%'; /* Does NOT work */
Am I doing something wrong?
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]