title: SQL find in other field data and update another field
body: <p>I have troubles with doing such sql query for mysql db:
  I need to update field A in my db, but also i have B field, which contains much data, for example:</p>
  
  <pre><code>ASIAN HORSE 70з рус 600A (261x175x220)
  </code></pre>
  
  <p>or </p>
  
  <pre><code>Бэрен polar 55/59з (555112) 480A (242x175x190) 
  </code></pre>
  
  <p>i must fetch 70з and set it in field A, and 55/59з same (but for another record). </p>
  
  <p>But how can i search in B field something what end's with <code>з</code> but is word (not all data as % before <code>з</code>)</p>
  
  <p>I know, that it could sound like homework... but i real don't know ho to select only word with some end...</p>