Below MYSQL query return the 10 most common value (words) in a post_title(column) FROM wp_posts(table):
SELECT post_title, COUNT(post_title) AS Appearances FROM wp_posts GROUP BY post_title ORDER BY Appearances DESC LIMIT 10
Below MYSQL query return the 10 most common value (words) in a post_title(column) FROM wp_posts(table):
SELECT post_title, COUNT(post_title) AS Appearances FROM wp_posts GROUP BY post_title ORDER BY Appearances DESC LIMIT 10