List:MySQL on Win32« Previous MessageNext Message »
From:Billy Yard Date:August 7 2004 1:34am
Subject:[0-9] won't work
View as plain text  
I tried the query (with mysql and query browser and control center) 

select * from disk where code like 'bs[0-9]%' and i get an empty set.  There should be a
lot of records.

when I try

select * from disks where code like 'bs0%' i get a result set.

The query works fine in MS SQL Server.  Is this a bug In MySQL?

The version is 4.0.18nt


Thread
[0-9] won't workBilly Yard7 Aug
  • Re: [0-9] won't workPaul DuBois7 Aug
  • Re: [0-9] won't workBilly Yard7 Aug
    • Re: [0-9] won't workPaul DuBois7 Aug
  • Re: [0-9] won't workBilly Yard7 Aug
    • Re: [0-9] won't workGRAEME F ST CLAIR8 Aug