On Apr 18, 2007, at 8:40 AM, Jose Soares wrote:
>
> Disrupt07 ha scritto:
>> I have a users table and I want to query the usernames column. I
>> want
>> my query to ignore the upper/lower casing.
>>
>> So the following searches should all match "John": "john", "jOhn",
>> "johN, "JOhn", and s
Disrupt07 ha scritto:
> I have a users table and I want to query the usernames column. I want
> my query to ignore the upper/lower casing.
>
> So the following searches should all match "John": "john", "jOhn",
> "johN, "JOhn", and so on.
>
> My query at the moment is a follows:
> names = query
there was some thread about this 2week ago or so, look for ILIKE
On Wednesday 18 April 2007 14:58:41 Disrupt07 wrote:
> I have a users table and I want to query the usernames column. I
> want my query to ignore the upper/lower casing.
>
> So the following searches should all match "John": "joh
