Refreshing data in different tables in SQL Server
From the nvarchar type you are using MSSQL. Now in MySQL you can use a subquery in the update .. where the clause, but MSSQL has its own update .. from the clause:
UPDATE table2 SET table2.pubVisited = null FROM table1 WHERE table2.playerID = table1.playerID and table1.nationalities = 'England'
Haven't tested it, although it might not work.
source to share