SQLite Forum

How to select columns that have name beginning with same prefix?
Login
If you have a big pile of column names where meanings are encoded in portions of the names, then you would be better off devising a schema where that data can be incorporated into queries by less devious means.