Replace and append part of a String - MySQL

Question

In my table I have a field "youtube" where the user can add a Youtube or Vimeo link. The Youtube links can be played directly, the Vimeo links which looks like:

https://vimeo.com/22614651XX

needs to be replaced by:

https://player.vimeo.com/video/22614651XX

Can this be done with SQL or should it be done in PHP? In PHP I found the substr() Function where I can split a string, but I have no clue how to deal with the numbers as they can vary in length...

If the urls are well formed the simplest thing is a single dumb replace()/str_replace() swapping https://vimeo.com/ for https://player.vimeo.com/video/ — Alex K.
– Alex K., Commented Nov 14, 2017 at 17:09
MySQL's REPLACE function or PHP's str_replace function should to the trick just fine. — Raymond Nijland
– Raymond Nijland, Commented Nov 14, 2017 at 17:14
Something like REPLACE(column, 'https://vimeo', 'https://player.vimeo') should do it. Use that with an update if you want it stored that way. — chris85
– chris85, Commented Nov 14, 2017 at 17:33

Bosstone · Accepted Answer · 2017-11-14 21:19:31Z

1

thank you for your assistance :-)

UPDATE wp_awa_upload
SET youtube = REPLACE(youtube, 'https://vimeo.com/', 'https://player.vimeo.com/video/')
WHERE youtube like "%vimeo%"

does the trick :-)

Kind Regards,

Stefan

answered Nov 14, 2017 at 21:19

Bosstone

1891 silver badge12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Replace and append part of a String - MySQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related