title: Mysql count days of rain of table
body: <p>I would like to know how many days in a period it rains (rain > 0.1) consulting with mysql.</p>
  
  <p>I use this code, but it gives me back all days, with and without rain</p>
  
  <pre><code>$result = mysqli_query($con,"SELECT City, count(Rain &gt; '0.1') as Total FROM Meteo2 where Data BETWEEN '" . split($_POST["date6"]) ."' AND '" . split($_POST["date7"]) ."' group by City");
  </code></pre>
  
  <p>tks</p>