[sqlite] SQL Help: Finding case insensitive matches

[Dominique Devienne]

On Fri, May 13, 2016 at 5:27 PM, John McKown
<john.archie.mckown at gmail.com> wrote:
>> > select group_concat(user) from os_users group by upper(user) having
>> count(*) > 1
>> foo,FOO
>>
>
> how about: SELECT group_concat(user,"|") FROM os_users GROUP BY
> upper(user) HAVING count(*) > 1

Thanks John. Sorry, I wasn't clear. When I wrote foo|FOO, I meant 2 columns,
i.e. col1 = "foo", col2 = "FOO", not the "foo|FOO" text value in a
single column. --DD