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