[sqlite] Getting a list of items on a column

[jose isaias cabrera]

Greetings!
imagine this data content,

c1, c1, c3
a, 1, 2
b, 3, 4
c, 5, 6
a, 9, 8
a, 1, 9
c, 1, 3

I would like to get a list of all the items in c1.  So, the return would be,

a,
b,
c

I know how to do it programmatically, but is there a way to get it right 
from SQLite?

thanks,

josé


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------