title: SQLAlchemy Where Value in List of Columns
body: <p>Before moving my code to SQLAlchemy, I have a MySQL query that looks for a value in multiple columns (ex - <code>WHERE 'value' in (col1, col2)</code>) which works fine when submitting the query manually to the database.</p>
  
  <p>The use case above is relatively simple, but in the future I may want to run a similar query on more than two columns so just want to get ahead of this problem now.</p>
  
  <p>Currently I have converted my query to the below (which works), but I am trying to find a similar syntax to the one above.</p>
  
  <pre><code>metadata = sqlalchemy.MetaData(mydb, reflect=True)
  select_stmt = (tbl_pbp.select(
                ((tbl_pbp.c.home_team == team_abbreviation) | (tbl_pbp.c.away_team == team_abbreviation))
                &amp; (tbl_pbp.c.is_corsi == True)))
  </code></pre>
  
  <p>When I try the below, I get a syntax error so not sure if it is an issue with the <code>in_</code> keyword I am trying to use.</p>
  
  <pre><code>metadata = sqlalchemy.MetaData(mydb, reflect=True)
  select_stmt = (tbl_pbp.select(
                (team_abbreviation in_(tbl_pbp.c.home_team, tbl_pbp.c.away_team)
                &amp; (tbl_pbp.c.is_corsi == True)))
  </code></pre>
  
  <p>Any help is greatly appreciated - thanks!</p>