title: SQL Difference Between "a%" and "a%_"
body: <p>I have been searching on good use-cases and differences between the use of LIKE and = where I faced this problem regarding LIKE.</p>
  <p>Since LIKE <strong>&quot;_r%&quot;</strong> means <strong>those with 'r' as their second character</strong>, doesn't it hold to assume that <strong>&quot;r%_&quot;</strong> means <strong>those with 'r' as their first character</strong>, essentially making it <em>functionally same</em> as &quot;a%&quot;.</p>
  <p>I am asking this because our lecture slides says the otherwise, and I am not sure whether I am wrong or not. I have also ran this SQL test program (<a href="https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_like_underscore" rel="nofollow noreferrer">https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_like_underscore</a>) to see it firsthand and this also proves my point.</p>
  <p>Have a good day.</p>