[Bacula-users] Re: case insensitive query

2006-04-19 Thread Mark Nienberg
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)

[Bacula-users] Re: case insensitive query

2006-04-19 Thread Mark Nienberg
Cedric Tefft wrote: 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 Filen