title: SQL query to prepend prefix to existing value in a field
body: <p>I have searched and searched for an answer to this, and I think this must be child's play for anyone who KNOWS SQL (which is not me).</p>
  
  <p>I want to insert a prefix to the values in a field of a table in my DB.</p>
  
  <p>More specifically, I have a table jos_content in which I have a field 'title' (which contains the titles of the content items of my joomla site).</p>
  
  <p>All the values in this field 'title' are names of individuals. Now all I want to do is add a prefix 'Mr.' to all the values of this field. </p>
  
  <p>I can do this from phpmyadmin by clicking the edit pencil icon and simply adding Mr. in front of all the values but I have about 750 rows and an SQL command which can insert a prefix of 'Mr.' in front of all values of this field will be a great help.</p>
  
  <p>I have read about the 'UPDATE' commands but that REPLACES the value with what you provide. But I want to let the values remain and add a prefix before them.</p>
  
  <p>Please can anyone help me achieve this with a SQL command ?</p>
  
  <p>Thanks a ton.</p>