title: How to do a COUNTIF formula with mysql
body: <p>I'm looking at some keyword rankings and need to bring back data on the number of keywords a URL has increased rank for, decreased rank for, stayed the same for. My data looks like this:</p>
  
  <pre><code>URL | Keyword | Position | Previous position | Keyword  Movement
  
  example.com/page1 | things to do london   | 38 | 101| Up
  example.com/page2 | mens shoes size 8     | 48 | 94 | Up
  example.com/page3 | notebooks             | 22 | 2  | Down
  example.com/page4 | macbook pros for sale | 52 | 52 | Same
  example.com/page1 | homebrew supplies     | 56 | 46 | Down
  example.com/page2 | sql tutorials         | 70 | 39 | Down
  example.com/page3 | random seo keywords   | 88 | 36 | Down
  example.com/page4 | best albums of 2017   | 94 | 95 | Up
  example.com/page5 | fender stratocaster   | 19 | 9  | Down
  example.com/page6 | qotsa                 | 91 | 34 | Down
  </code></pre>
  
  <p>I'd like to have a table showing the URL, number of keyword increases, no. of keyword decreases, and no. of keywords staying the same. In Excel this can be done with a countif formula but not sure how to do this with mysql. I'd like a table looking like the following:</p>
  
  <pre><code>URL |Keywords Up |Keywords Down |Keywords remain
  
  
  example.com/page1 | 1 | 1 | 0
  example.com/page2 | 1 | 1 | 0
  example.com/page3 | 0 | 2 | 0
  example.com/page4 | 1 | 0 | 1
  example.com/page5 | 0 | 1 | 0
  example.com/page6 | 0 | 1 | 0
  </code></pre>
  
  <p>I'm looking for a way of doing a countif on the "Movement" column.</p>
  
  <p>Thanks.</p>