title: MariaDB Query works and MYSQL does not
body: <p>I have two web sites with identical database tables.  If the following query is run on the site using 10.2.25-MariaDB-log it works, but if run on the site using MYSQL 5.6.45 it does not. Here is the query:</p>
  
  <pre><code>SELECT masterpoints_total, FIND_IN_SET( masterpoints_total, 
  ( SELECT   GROUP_CONCAT( masterpoints_total ORDER BY masterpoints_total
  DESC ) FROM `members` ) ) AS rank FROM members WHERE number = "N433975"`
  </code></pre>
  
  <p>On the MYSQL Maria site the results are 1033(masterpoints_total) and 630(rank) while on the MYSQL site the results are 1033 and 0. Zero is not correct.</p>
  
  <p>How can I fix the MYSQL site to properly show the rank?</p>
  
  <p>Thanks.</p>