title: Find item in array returned from sql query
body: <p>I have an array(list?), like below, which is the result of a sql query.</p>
  
  <pre><code>lstLineRouteKey = [('1203/1000/2', 1, 'DVN 1000'), ('1212/1000/2', 2, 'RKS 1000'), ('1189/1000/2', 3, 'USH 1000'), ('1201/1000/2', 4, 'ANA 1000'), ('1232/1000/2', 5, 'CLB 1000'), ('1207/1000/2', 6, 'HRY 1000'), ('1162/1000/2', 7, 'LBR 1000')]
  </code></pre>
  
  <p>What I'm trying to do is find the first(only) instance of '1212/1000/2' and retrieve the value to the right of it, 2 .</p>
  
  <p>I have managed to do that with a for loop, below, but it is very inefficient, as it's looping through the entire list, even after it's found a match.</p>
  
  <pre><code>for id,row in enumerate(lstLineRouteKey):
                      lst = list(row)
                      for id,s in enumerate(lst):
                          if lst[0] == '1212/1000/2':
                              ID = str(lst[1]);
  </code></pre>
  
  <p>I've been unsuccessful with the methods(.find, .map) I've found thus far, as none of the lists resemble my structure above.  Assistance will be greatly appreciated!  </p>