vendredi 22 avril 2016

sqlite comma separated integer in a text column

I have a sqlite text column with comma separated integer like 3,899,550. How can I use this value as an integer? I want to filter by values greater than 1million.

select * from table_t where some_func(comma_sep_column) > 1000000?

Aucun commentaire:

Enregistrer un commentaire