title: Is there any alternative for CONCAT() in MySQL?
body: <p>I want to add a constant string to all result of one column. Here is my table:</p>
  
  <pre><code>// mytable
  
   id | name
  ----|--------
   1  | jack
   2  | peter
   3  | ali
  </code></pre>
  
  <p>I want this output:</p>
  
  <pre><code>select name from mytable order by id;
  
  Your name: jack
  Your name: peter
  Your name: ali
  </code></pre>
  
  <p>As you see, I have combined all results of <code>name</code> column with this string: <code>Your name:</code>. I can do that like this: </p>
  
  <pre><code>... CONCAT('Your name: ', name) ... 
  </code></pre>
  
  <p>Now I want to know, is there any approach else? (something like combining by <code>+</code> in MySQL)</p>