title: Mysql: Find rows where column value ends with a specific substring
body: <p>I have a column <code>url</code> where all the values are urls. I'm trying to update the value of a different column where-ever the aforementioned url ends with <code>.pdf</code>.</p>
  
  <p>Can anyone help me with this? I haven't found an answer here on SO.</p>