mysql match columns

I have two tables with albums names almost similar, but not quite.

Below are just random example

Table 1: album name= Khan Boh
Table 2: album name= Khan Boh mp3 2019 songs.

how can I update table 1 fields based on album name from Table2. In php or javascript? I tried using Left function. it doesn't work as much as I need to.

If fields are similar, then you have to implement some algorithm for matching.
There is no internal tool in MySQL for fuzzy matching or something..
You can make a subquery to find rows that starts with the same word, for example.
All depends on logic behind matching those columns.