title: Convert string representation of a list in sqlite3 database while making SELECT command
body: <p>I have an sqlite3 database, where one of the columns contains a string representation of a list (ex: "['hello', 'there', 'example']"). I need to use a SELECT command and the LIKE clause to extract rows where an element of such a 'list' contains a certain substring. I know how to build a command that extracts rows that have a column whose value contains a substring, but I do not know how to check if the individual elements of the 'list' in a column (that is represented as a string) contain a substring. Here's the code I know how to write for retrieving columns that contain a substring. </p>
  
  <pre><code>SELECT * FROM yourDatabase WHERE UPPER(column) LIKE UPPER(?)",('%'+substring+'%',)
  </code></pre>
  
  <p>Note: I could just read every row of the database convert that 'list' column into an actual list, and then check for the substring in the elements of that list, but that seems REALLY inefficient.</p>