Fastest way to compare two columns using like in two differents tables in MYSQL, half millions rows
I have a MYSQL database with a table ‘product’, about 500 000 rows, with a column ‘oem’ (varchar 255, utf8_unicode_ci). I have another table ‘oem’ with a column ‘oem’ too (varchar 255, utf8_unicode_ci), about 150 000 rows.