title: Using the correct, or preferable, not equal operator in MySQL
body: <p>Which of the two (semantically equivalent) ways is preferable to test for inequality?</p>
  
  <ol>
  <li><code>'foo' != 'bar'</code> (exclamation mark and equals sign)</li>
  <li><code>'foo' &lt;&gt; 'bar'</code> (less than and greater than chevron symbols together)</li>
  </ol>
  
  <p>The MySQL documentation clearly indicates that there is no difference between them and yet some people seem to be attached to only doing it one way or the other.  Maybe this is just another pointless vi vs. emacs debate but when other people are reading your code (and therefore your queries), it's useful to maintain some consistency.</p>
  
  <p><code>&lt;&gt;</code> looks a lot like <code>&lt;=&gt;</code> which is a very underused operator but could perhaps lead to confusion at a quick glance since the two are nearly opposite (except for the obvious <code>NULL</code> cases).</p>