Re: [Bacula-users] Filename searching and case insensitivity
2011-04-09 11:06:15
On Apr 5, 2011, at 10:19 PM, Kernel Panic wrote:
> On 6 April 2011 02:37, Dan Langille <dan AT langille DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
|
|