title: SELECT rows NOT ending in a specific character
body: <p>I have a table of questions. I need to find rows which have '?' in the question text because of bad character encoding/collation. I need to find all the rows which have '?' but also need to ignore the question marks at the end of the questions. I tried this query but I still get rows with questions marks at end of the question</p>
  
  <pre><code>SELECT * 
  FROM `kc_questions` 
  WHERE `question` LIKE "%?%" /* WHICH CONTAINS '?' */
  AND `question` NOT LIKE "%?"  /* DOES NOT END WITH '?' */
  </code></pre>
  
  <p>EDIT: phpmyadmin actually tells me there is something wrong with the query:
  <a href="https://i.stack.imgur.com/pLQnc.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pLQnc.png" alt="enter image description here"></a></p>
  
  <p>The query however runs successfully returning rows which end with'?'.</p>