On Apr 5, 2011, at 10:19 PM, Kernel Panic wrote: > On 6 April 2011 02:37, Dan Langille <d...@langille.org> wrote: >> >> On Apr 5, 2011, at 9:31 PM, Kernel Panic wrote: >> >>> Hello everyone, >>> >>> Whilst trying to find a way of doing a case-insensitive search for >>> file, I found previous posts on the mailing lists that instructed me >>> to use the sqlquery function in bacula. As a test I wanted to search >>> for files with zfs in their name and then with ZFS in the name. After >>> starting up bconsole and entering sqlquery mode I did the following: >>> >>> USE bacula; >>> SELECT * FROM Filename WHERE name LIKE '%ZFS%'; >>> SELECT * FROM Filename WHERE name LIKE '%zfs%'; >>> >>> Although the commands worked, they only returned case-sensitive >>> matches, despite MySQL's documentation stating that pattern matching >>> is case-insensitive by default: >>> http://dev.mysql.com/doc/refman/5.5/en/pattern-matching.html >>> >>> Can anyone help me? >> >> Have you tried ilike instead of like? It is available on PostgreSQL. I >> don't know about MySQL. >> >> Consider also: >> >> SELECT * FROM Filename where lower(name) LIKE %zfs%; > > Unfortunately ilike/ILIKE do not seem to be valid operators in MySQL. > The lower(name) doesn't cause a problem but the results are still > case-sensitive
Think wider. It is not case insensitive. It is all lower case. You are comparing lower case to lower case. Does that help? ------------------------------------------------------------------------------ Xperia(TM) PLAY It's a major breakthrough. An authentic gaming smartphone on the nation's most reliable network. And it wants your games. http://p.sf.net/sfu/verizon-sfdev _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
