I think I understand but as the Filename column in the Bacula script
is created with the BLOB data type then according to the documentation
the lower() function does not work:
http://dev.mysql.com/doc/refman/5.5/en/string-functions.html#function_lower
It says I need to convert it into a non-binary string, I don't really
have any SQL skills at all but I'll see what I can do :)
On 9 April 2011 16:01, Dan Langille <dan AT langille DOT org> wrote:
>
> 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
|
