mysql inner join with wildcard

0

I need to update on a table A by taking information from table B using inner join with wildcard to compare a snippet of content and if found in B, load a column in A. To just test this join I made the select below:

SELECT
vinhos.*
FROM vinhos
INNER JOIN 'winemag-data-130k-v2'
ON '%' + vinhos.DESCRICAO + '%' LIKE '%' + winemag-data-130k-v2.winery + '%'

But unfortunately it is not working. How can I perform the update using this query (the select was only test)?

    
asked by anonymous 24.06.2018 / 21:00

0 answers