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
in the videos table we have a column url
this should match the title of that video the url is

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