man Mission Systems
From: sqlite-users-boun...@sqlite.org on behalf of Peng Yu
Sent: Wed 7/14/2010 11:36 AM
To: General Discussion of SQLite Database
Subject: EXTERNAL:[sqlite] Case insensitive join available?
Hi,
I'm wondering if there is a syntax to do case insensitive join. Of
course, I cou
On Wed, Jul 14, 2010 at 11:36:06AM -0500, Peng Yu scratched on the wall:
> Hi,
>
> I'm wondering if there is a syntax to do case insensitive join. Of
> course, I could generate two new tables, with the both joining columns
> converted to lower case (or upper case). But I'd like a simpler
>
Hi,
I'm wondering if there is a syntax to do case insensitive join. Of
course, I could generate two new tables, with the both joining columns
converted to lower case (or upper case). But I'd like a simpler
solution.
#!/usr/bin/env bash
rm -f main.db
sqlite3 main.db
3 matches
Mail list logo