title: Like query in Python - SQLite
body: <p>I have a database with 2 columns, with the name of the players written in this format:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: center;">Player1</th>
  <th style="text-align: center;">Player2</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: center;">Yang Y.</td>
  <td style="text-align: center;">Ying G.</td>
  </tr>
  <tr>
  <td style="text-align: center;">Kim G.</td>
  <td style="text-align: center;">Uin Y.</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I should find all the rows containing the name of the players but only with the surname, like Yang, without Y.</p>
  <p>So I thought to use the LIKE query, like this:</p>
  <pre><code>for game in final_table:
    name = &quot;Yang&quot;
    cur1.execute(&quot;SELECT * FROM matches WHERE Player1 like ?&quot;, [name])
    match = cur1.fetchall()
  
  print(match)
  </code></pre>
  <p>It gives me nothing in return. Instead if I write the entire name like this:</p>
  <pre><code>for game in final_table:
    name = &quot;Yang Y.&quot;
    cur1.execute(&quot;SELECT * FROM matches WHERE Player1 like ?&quot;, [name])
    match = cur1.fetchall()
  
  print(match)
  </code></pre>
  <p>It works properly.
  What am I doing wrong?</p>