Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2016

    Question Unanswered: Mapping 2 tables

    Hi, I need a query to map two tables with large number of keywords and obtain the partial match results. I have 150K unique keywords in 1 table and 60k unique Keywords in 2nd table. I would like to check if the whole keyword from a table can be found within any keyword from another table. I have attached the image below for better understanding. Plz provide me a mysql query to accomplish that task.

    Click image for larger version. 

Name:	table.png 
Views:	3 
Size:	2.5 KB 
ID:	17162

  2. #2
    Join Date
    Oct 2007
    Provided Answers: 9
    you mean something like:

    select count(*) from table1 a
    inner join table2 b
    on a.key1 = b.key1
    and a.key2 = b.key2

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts