sqlite - Get a list of field values from Python's sqlite3, not tuples representing rows -

It is annoying that the Python module always gives a list of Tuples! When I ask for a single column, I would like to get a simple list.

For example, when I execute

  select something from  

and call

< Pre cursor.fetchall ()

this return

  [(u'one ',), (u'two',), (U'three ',)]  

but I just can not get it

  [u'one', u'two ', u'three ']  

Is there a way to do this?

You really do not want to do this - whatever you do is use the zip or the understanding of the list Lines are eating CPU cycles and playful memory without adding important chakra only. You are offering better service to tackle the Tuples.

Why gives this tuepals, that's because it is necessary from fetchall .