title: MySQL query result that use value of other fields
body: <p>I'm looking for something like <code>format()</code> in other programming languages in MySQL query. The expected result is text that has values from other fields.</p>
  
  <p>For example, something like</p>
  
  <p><code>select formatted from table where formatted=stringformat('some text {0}, {1} some text.', field1, field2)</code></p>