title: MYSQL search if a string contains special characters?
body: <p>I need to search table field contains special characters. I found a solution given <a href="https://stackoverflow.com/questions/2558755/how-to-detect-if-a-string-contains-special-characters">here</a> something like:</p>
  
  <pre><code>SELECT * 
  FROM `tableName` 
  WHERE `columnName` LIKE "%#%" 
  OR `columnName` LIKE "%$%" 
  OR (etc.)
  </code></pre>
  
  <p>But this solution is too broad. I need to mention all the special characters. But I want something which search something like:</p>
  
  <pre><code>SELECT *
  FROM `tableName`
  WHERE `columnName` LIKE '%[^a-zA-Z0-9]%'
  </code></pre>
  
  <p>That is search column which contains not only a-z, A-Z and 0-9 but some other characters also. Is it possible with <code>MYSQL</code></p>