title: How to search the MySQL entries shown as decimal numeric character reference(NCR) &#xxxxx?
body: <p>When I am searching my MySQL database with some query like:</p>
  
  <p><code>SELECT * FROM mytable WHERE mytable.title LIKE '%副教授%';</code></p>
  
  <p>("副教授" are three Chinese characters, whose decimal numeric character reference, NCR, is "<code>&amp;#21103;&amp;#25945;&amp;#25480;</code>"), I got no result. </p>
  
  <p>By looking into the phpMyadmin and browsing "mytable", the should-be-found entry is shown as "<code>&amp;#21103;&amp;#25945;&amp;#25480;</code>". I think that is the reason for the failure of search.</p>
  
  <p>Not all the entries in the same column are numeric character reference and some of them are just normal. Here is one pic of the table column shown in phpMySQLAdmin. </p>
  
  <p><a href="https://i.stack.imgur.com/DSxQf.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DSxQf.png" alt="enter image description here"></a></p>
  
  <p>I wonder how I could search for all entries in my table in MySQL using one format regardless if there are shown in NCR or not. Or should I convert the NCR entries by running some script? Thanks.</p>