title: How to select a row by primary key in sqlite3?
body: <p>I'm trying to find a way to select a row in sqlite from Python. Say I have a table <code>soft drinks</code> with columns <code>drink</code> and <code>price</code>, with the primary key being <code>drink name</code>. I want to select <code>coke</code> out of <code>drink</code> name. How would I do this without looping through every single entry?</p>
  
  <p>Here's my code:</p>
  
  <pre><code>conn = sqlite3.Connection("database.db")
  curs = conn.cursor()
  curs.execute("create table soft drinks (drink name TEXT, drink TEXT, price INTEGER)"
  curs.execute("insert into soft drinks (drink name, drink, price) values ("coke", "whatever", 89)")
  </code></pre>
  
  <p>I'm looking for a command something like <code>curs.execute(select "coke" from soft drinks)</code> and it will return the whole row.</p>