samedi 9 juillet 2016

how to remove anything after youtube id using mysql?

Hello guys I have a mysql table with a column named ae_url which has youtube urls in it, and I would like to remove anything after the youtube id. For example: http://www.youtube.com/watch?v=1B6tWkbso1o&feature=youtu.be remove "&feature=youtu.be"

There are some cases when a playlist comes after youtube id as well.

How can I accomplish this task using mysql queries ? I have to update the column ae_url which contains thousand of youtube urls by removing anything anything after youtube id

Thank you so much for your kind assistance :)

Aucun commentaire:

Enregistrer un commentaire