MYSQL QUERY UPDATE SEARCH NEEDED -- 3
Budget: $10 – $30 USD
we have 2 tables one is videos the other is titles
there is a column in videos titles_id which is is associated to the table titles.id
in the videos table we have a column url
this videos.url should match the title of that video the url is website.com/NAME_OF_VIDEO.YEAR_OF_FILM/NAME_OF_VIDEO.YEAR_OF_FILM.mp4
in the titles table we have id , name , year
we need help getting the videos correct to the title ids
there are only a few which need fixing
from what we have found the import we did has associated the same name but the wrong year for the movie
we need some one with AMAZING mysql QUERY skills to write a script that will search name year against the url and find the title id and change the videos.titles_id
there is a column in videos titles_id which is is associated to the table titles.id
in the videos table we have a column url
this videos.url should match the title of that video the url is website.com/NAME_OF_VIDEO.YEAR_OF_FILM/NAME_OF_VIDEO.YEAR_OF_FILM.mp4
in the titles table we have id , name , year
we need help getting the videos correct to the title ids
there are only a few which need fixing
from what we have found the import we did has associated the same name but the wrong year for the movie
we need some one with AMAZING mysql QUERY skills to write a script that will search name year against the url and find the title id and change the videos.titles_id