title: How do I update first record in a table using mysql?
body: <p>I have an unknown amount of records in the 'room_photos' table. There is a column named 'main_photo' and currently each of the records has a value of 'no' for that column. I would like to create a sql statement that updates the first record in the table and changes the value of the 'main_photo' column to 'yes'.</p>
  
  <p>So this is what I have now:</p>
  
  <p>TABLE <strong>room_photos</strong><br />
  <strong>photo_id</strong>  &nbsp;&nbsp;|&nbsp;&nbsp;  <strong>main_photo</strong><br />
  51 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;no<br />52 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;no<br />53 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;no</p>
  
  <p>And this is what I need:</p>
  
  <p>TABLE <strong>room_photos</strong><br />
  <strong>photo_id</strong>  &nbsp;&nbsp;|&nbsp;&nbsp;  <strong>main_photo</strong><br />
  51 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;yes<br />52 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;no<br />53 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;no</p>