Get the most repeated post contents from a search?

The problem with your approach is that post’s content pretty much ignored in WordPress query architecture. It is meant to be textual information, as opposed to technical meta information.

You have several options:

  1. Try to modify raw SQL of query request through filters, such as posts_where.

  2. Assign school name to custom field and use custom fields parameters in query (much enhanced in upcoming 3.1 version of WP).

  3. As per hakre’s suggestion create custom taxonomy and assign schools to posts as its terms.

Related Posts:

  1. Export WordPress Posts and Meta Information in CSV format
  2. how to get permalink using sql
  3. Use Cron to modify posts via sql
  4. Sql syntax error
  5. get posts and postmetas in assoc array
  6. How do I find which articles are missing a featured image in The WordPress database?
  7. Bulk update post slugs through database
  8. Multiples Empty Posts were created and cannot delete them
  9. Delete WordPress posts from URL list sql query
  10. SQL query to retrieve all the records that have not indicated category
  11. How to verify wp user password by sql query in wp? [closed]
  12. Get ALL post ID’s export list (Only id’s. Php or sql not important )
  13. WordPress website loads more posts than expected
  14. SQL Command for restoring trashed comments
  15. How to Assign / Move all Deleted post to a category
  16. Migrate posts from category and sub-category via SQL
  17. SQL Bulk Move old posts by one author to another category
  18. Export all posts to import as product items
  19. How can I get posts from 9/13/11 to today with SQL? [closed]
  20. Change published date and time using SQL query for page in every 5 hour
  21. SQL DELETE multiple post_meta on single and multi-sites
  22. Bulk find & replace on WordPress posts/pages (minus image paths)
  23. SQL query: select duplicate posts – but using duplicate meta [duplicate]
  24. WordPress MySQL Search and replace with wildcard?
  25. Using a meta_value or postdate to to query and orderby
  26. insert post fails after multiple postings
  27. Adding wordpress posts using phpmyadmin
  28. How to run select query of post with category and tags?
  29. Export Posts with specific custom fields by sql
  30. Query to get data of a post, if in category?
  31. Can’t create posts with WP DB Abstraction Plugin
  32. SQL query to remove first image in all posts
  33. Delete junk text from all the post using my sql command
  34. Special Query: Title, Terms, Content – %LIKE%
  35. If meta_key exists then don’t select this post?
  36. The page that displays Posts on homepage
  37. Change permalinks in posts via SQL
  38. Batch Scanning and Deleting Empty WordPress Posts
  39. Post/Page Preview Template
  40. Post slugs and images cannot have same name?
  41. Convert custom fields to post categories
  42. Hide password protected posts in admin
  43. Most viewed post for the last 2 days using WP_Query
  44. This AJAX Code Doesn’t Work – Looking for elegant solution
  45. Do I use custom post type or something else?
  46. How To Add Perfect Apostrophe And Quotation Mark In WordPress Posts?
  47. Custom post type permalinks breaking due to 3.1 bug fix
  48. Locked/Unlocked in title
  49. How to permanently delete a post meta entry?
  50. Loop through all product posts?
  51. Inserting custom data to the_post() during loop
  52. Get Image tag from content of post
  53. Visting slug for ‘post’ post type shows 404 not archive?
  54. Remove Custom Post Type Slug and add Custom Taxonomy to Permalink Structure?
  55. Automatically create a new page daily with last three posts
  56. Add filter to the end of the post
  57. Indirect modification of overloaded property WP_Post::$ancestors has no effect
  58. How do I change the location of post-specific information?
  59. Benefits to using semantic HTML in post content? [closed]
  60. How can I insert a new markup element after 4 posts automatically? [closed]
  61. the_excerpt is displaying excerpts of every post
  62. Using wp_tag_cloud with only posts published in specific year
  63. Post: how to set created date after post has been published [closed]
  64. WordPress loop not working on static front page
  65. Sidebar on single.php not showing up
  66. remove all custom post created
  67. Hide content from Post Preview
  68. How to get the next and previous image title from attachment or gallery?
  69. Pagination for posts inside a specific category
  70. Creating a redirect option for current page url
  71. How to edit a custom theme?
  72. WordPress posts have a different URL to the index
  73. How to put the author of the post in the comments?
  74. Blog posts pagination not working
  75. unable to write to the database while uploading images
  76. Restricting displayed posts to posts from only select authors
  77. How can I create a Survey Form in WordPress that users can fill in and then submit the entire survey contents as a post?
  78. How to Make my Homepage Display a Single Specific Post?
  79. wp_query args with relation
  80. Creating Ordered Query using Meta_key
  81. WordPress each user has each content for a page,how to do that?
  82. Fixing the WP Post Object for Custom Route
  83. How to change post template via url?
  84. How to remove related post from home page
  85. Is there a Standard Format for Clean URLs for Archives of Custom Posts?
  86. Send/Publish a Post front end
  87. How do I list categories and the common categories for posts beneath those categories?
  88. Post restoration
  89. Insert new post for each user infinite loop error
  90. Last three posts not being put in order by date. How to fix this?
  91. WordPress sub-posts and permalinks
  92. Assign a link of a post to that contains that post?
  93. wp_query posts sorting doesn’t work
  94. Show List of Posts With Comments Open
  95. When and how will php code in a user made WordPress page be executed?
  96. There is a page on my website that doesn’t show in the Pages section of WordPress [closed]
  97. Difficulty hiding a span per a body class within WordPress
  98. Onclick open posts displayed in slider in a popup [closed]
  99. Listing category and its posts one by one
  100. How to get post ID after removing that post?