CREATE TABLE mytable ( id INTEGER PRIMARY KEY, element TEXT, items TEXT, item TEXT, data TEXT, UNIQUE(element, items, item, data) ); #### sqlite> SELECT ("element" || "/" || "items" || "/" || "item" || "/" || "data") AS source where source like '%some string%';