title: Can MySQL concatenate strings with ||
body: <p>I'm using sqlite3 for the moment, and hence concatenation strings using the <code>||</code> operator. </p>
  
  <p>At some later date I'd like to shift to MySQL, and hence it would be nice if no changes to the code had to be made. I'd normally use <code>concat()</code> to concatenate in MySQL. Does <code>||</code> work too, or will I have to modify my code? Or is there any other solution?</p>
  
  <p>I'm coding in Ruby on Rails 3.1, by the way.</p>