title: LOCATE vs INSTR
body: <pre><code>    SELECT INSTR('1234','2')  #returns 2
      SELECT LOCATE('2','1234') #returns 2
  </code></pre>
  
  <p>Besides the argument numbering are there any significant differences to be aware of before choosing either of the functions?</p>