title: MySQL how to copy data from one table to another table based on User ID value
body: <p>I'm not good at coding at all so I need some help in figuring this out.</p>
  
  <p>I have two tables one named 'registration' and one named 'users'.</p>
  
  <p>In the 'registration' table i have a field called "officers name" which is filled with integers ranging from 1 to 40.  These values correspond to "User ID" (primary key) value in the 'users' table, which corresponds to a persons name in the "full name" field.  </p>
  
  <p>What I need to be able to do is have whatever the value is in the "officers name" field, replace it with whatever value is in the "Full name" field with the corresponding integer value.</p>
  
  <p>my issue is that there are 1400 entries, and these values repeat multiple times, so I'm not even sure how I would go about doing that.</p>
  
  <p>Anyone have any ideas? </p>