You can also try "select Name from Filename where CAST(Name AS CHAR) = 'makedev';".
On my machine it was somewhat faster than CONVERT. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cedric Tefft Sent: Wednesday, April 19, 2006 3:33 AM To: Troy Daniels Cc: bacula-users@lists.sourceforge.net Subject: Re: [Bacula-users] case insensitive query Troy Daniels wrote: > An update to this. > > I cant vouch for this exact query - on my system it takes a looonnggg > time to finish due to the 2 million plus files recorded and I gave up > and canceled it, but the following simplified version worked: > > mysql> select Name from Filename where LCASE(Name) = 'makedev'; > +---------+ > | Name | > +---------+ > | MAKEDEV | > +---------+ > 1 row in set (1.15 sec) > > So I dont understand why it wouldn't work in the other query - but I'm > not a MySQL Guru. > > I am running MySQL Server 3.23.58 tho which could be the difference I > suppose. > Hmm... yeah, I tried that, but it didn't work for me, whereas the CONVERT() strategy does: mysql> select Name from Filename where LCASE(Name) = 'makedev'; Empty set (1.03 sec) mysql> select Name from Filename where CONVERT(Name using mysql> latin1)='makedev'; +---------+ | Name | +---------+ | MAKEDEV | +---------+ 1 row in set (1.85 sec) I am using mysql 5.0.18, though, like you, I don't know why that should make a difference. - Cedric ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
