title: How to update a specific field data in multiple rows in a table in phpmyadmin
body: <p>Here i have a number of data in a table, but i want to update on only one single fields data in that table.</p>
  
  <p>And i want to change these product_image field values with "https"</p>
  
  <p><strong>For example:</strong> </p>
  
  <p>this is my current value: <a href="http://weshareresources.s3.amazonaws.com/14619475790.jpg" rel="nofollow noreferrer">http://weshareresources.s3.amazonaws.com/14619475790.jpg</a></p>
  
  <p>and i want to change with: <a href="https://weshareresources.s3.amazonaws.com/14619475790.jpg" rel="nofollow noreferrer">https://weshareresources.s3.amazonaws.com/14619475790.jpg</a></p>
  
  <p><strong>database name</strong>: renters_test</p>
  
  <p><strong>table name</strong>: fc_rental_photos</p>
  
  <p><strong>name of field which i want to update</strong>: product_image</p>
  
  <p><strong>Here is my table screenshot:</strong></p>
  
  <p><a href="https://i.stack.imgur.com/nL9mF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nL9mF.png" alt="enter image description here"></a></p>
  
  <p>Please suggest me that one sql query, where i can replace these "http" with "https" with their following path. Thanks :)</p>