Update one column based on the first 3 letters of another : <p>can someone help show me how to update one field in my table based on the first 3 letters in another field in MySql?</p>

<p>in my tblpeople I have a column called location, in it are various codes but where the code starts VOL- then I need to update the country column to USA, if it starts HOM- then update to Canada and finally HOME to united kingdom</p>
