· 7 years ago · Dec 16, 2018, 10:20 AM
1CREATE TABLE IF NOT EXISTS Route (
2 id integer PRIMARY KEY UNIQUE AUTOINCREMENT NOT NULL,
3 name text NOT NULL,
4 localizedName blob NOT NULL
5);
6
7SELECT * FROM Route WHERE tkLocalizedString('en', localizedName) LIKE ?1;