title: Add string to mysql result
body: <p>I need mySql result with some prefixes and suffixes. This is my code:</p>
  
  <pre><code>SELECT bk_id, bk_rtype, villas_db.v_name AS villa_name
  FROM booking_db
  INNER JOIN villas_db ON booking_db.bk_vid = villas_db.v_id
  WHERE '2012-11-02'
  BETWEEN bk_date1
  AND bk_date2
  ORDER BY bk_id DESC
  LIMIT 0 , 30
  </code></pre>
  
  <p>The result are:</p>
  
  <pre><code>bk_id   bk_rtype    villa_name
  30          2           T2
  29          3           V1
  </code></pre>
  
  <p>So I need the result as:</p>
  
  <pre><code>bk_id   bk_rtype    villa_name     booking_no
  30          2           T2         B2-00030
  29          3           V1         B3-00029
  </code></pre>
  
  <p>While B is a booking prefix separate by "-" and sprintf("%05d",bk_id);</p>
  
  <p>Please suggest.</p>