Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT id_product,REPLACE(description, 'http://', 'https://') FROM ps_product_lang WHERE description REGEXP 'http:\/\/'
- UPDATE ps_product_lang SET description=REPLACE(description, 'http://', 'https://') WHERE description REGEXP 'http:\/\/'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement