I'm using SQLite3 to store data and Tkinter for gui. Basically, I have a ListBox and a page contained in a Frame and this page gets populated from a row that equals to the page index (int from 0 to all rows - 1). I store results of a search the ListBox and when a result is selected I need it to be displayed but I'm using the row indexes to get all the info from rows by executing select * from table_name limit 1 offset ? where ? is the page index. What I need is an inverse of the search function, which is select column_name from table_name where column_name = ? where ? is the term the user is searching for (a string like "%This%"). It needs to get the row number in the sqlite server from the column_name's content. I think it is possible since in this database all rows are completely unique so there's no chance of conflict. If not, I would like to see an alternative way for indexing the pages in a way that makes it possible to achieve what I'm trying to do Continue reading...
