I am posting this blog because I was facing issue to show the total common counts in 3rd column from two columns. This is following table which contain these records:
Solution was very simple, just write this query to get the output:
SELECT table1.title title1, table2.title title2
FROM table1, table2
WHERE table1.title LIKE CONCAT('%',table2.title,'%')
OR table2.title LIKE CONCAT('%',table1.title,'%');
0 Comment(s)