I am trying to develop a method whereby it will allow the user to search by a chosen field and value eg. SELECT * FROM table WHERE column_field = 'value'.
It executes just fine in SQL lite but when I bring it into my IDE nothing is printing out. Any advice much appreciated.
CodePudding user response：
'keyword' A keyword in single quotes is a string literal.
Suggest not quoting {field} in the queries.