title: MySQL (PHPMyAdmin) Find and replace
body: <p><strong>I am a real newbie here so I 'think' this is really basic but...</strong></p>
  
  <p>I have a table with 5 columns <strong>id</strong>, <strong>code</strong>, <strong>date</strong>, <strong>class</strong> and <strong>classname</strong></p>
  
  <p>I need to find cells in column '<strong>class</strong>' that equal '<strong>295</strong>' AND where cells in column '<strong>classname</strong>' are '<strong>empty/blank</strong>'</p>
  
  <p>On the results of this search I need replace the empty cells in column '<strong>classname</strong>' with 'Text Value X'</p>
  
  <p>Is there an SQL query that will do this? Or what is the best thing to do?</p>
  
  <p>Thank you for your help.</p>