Basic wordpress based sql query help needed

2 comments

1. You could try with:

   UPDATE wp_postmeta
   SET meta_value=CONCAT("image-1.png", meta_value)
   WHERE meta_key="file_1" OR meta_key="file_2" OR meta_key="file_3";
   

   Try it before. I didn’t test it.

   Log in to Reply

2. Something like this should work. See Update Syntax.

   UPDATE wp_postmeta
   SET meta_value =  CONCAT("image-1.jpg", meta_value)
   WHERE meta_key IN(file_1, file_2, file_3);
   

   Log in to Reply