Remove the post_content search from WHERE clause (and CONCAT sql function)

First look how complex is your preg replace. Usually, you may get into errors with that. 

NODE                     EXPLANATION
--------------------------------------------------------------------------------
  /                        "https://wordpress.stackexchange.com/"
--------------------------------------------------------------------------------
  \(                       '('
--------------------------------------------------------------------------------
  \s*                      whitespace (\n, \r, \t, \f, and " ") (0 or
                           more times (matching the most amount
                           possible))
--------------------------------------------------------------------------------
  post_title               'post_title'
--------------------------------------------------------------------------------
  \s+                      whitespace (\n, \r, \t, \f, and " ") (1 or
                           more times (matching the most amount
                           possible))
--------------------------------------------------------------------------------
  LIKE                     'LIKE'
--------------------------------------------------------------------------------
  \s*                      whitespace (\n, \r, \t, \f, and " ") (0 or
                           more times (matching the most amount
                           possible))
--------------------------------------------------------------------------------
  (                        group and capture to \1:
--------------------------------------------------------------------------------
    \'                       '''
--------------------------------------------------------------------------------
    [^\']+                   any character except: '\'' (1 or more
                             times (matching the most amount
                             possible))
--------------------------------------------------------------------------------
    \'                       '''
--------------------------------------------------------------------------------
  )                        end of \1
--------------------------------------------------------------------------------
  \s*                      whitespace (\n, \r, \t, \f, and " ") (0 or
                           more times (matching the most amount
                           possible))
--------------------------------------------------------------------------------
  \)                       ')'
--------------------------------------------------------------------------------
  /",       "              "https://wordpress.stackexchange.com/",       "'
--------------------------------------------------------------------------------
  (                        group and capture to \2:
--------------------------------------------------------------------------------
    post_title LIKE          'post_title LIKE '
--------------------------------------------------------------------------------
    $                        before an optional \n, and the end of
                             the string
--------------------------------------------------------------------------------
    1                        '1'
--------------------------------------------------------------------------------
  )                        end of \2
--------------------------------------------------------------------------------
   OR                      ' OR '
--------------------------------------------------------------------------------
  (                        group and capture to \3:
--------------------------------------------------------------------------------
    geotag_city LIKE         'geotag_city LIKE '
--------------------------------------------------------------------------------
    $                        before an optional \n, and the end of
                             the string
--------------------------------------------------------------------------------
    1                        '1'
--------------------------------------------------------------------------------
  )                        end of \3
--------------------------------------------------------------------------------
   OR                      ' OR '
--------------------------------------------------------------------------------
  (                        group and capture to \4:
--------------------------------------------------------------------------------
    geotag_state LIKE        'geotag_state LIKE '
--------------------------------------------------------------------------------
    $                        before an optional \n, and the end of
                             the string
--------------------------------------------------------------------------------
    1                        '1'
--------------------------------------------------------------------------------
  )                        end of \4
--------------------------------------------------------------------------------
                OR         '              OR '
--------------------------------------------------------------------------------
  (                        group and capture to \5:
--------------------------------------------------------------------------------
    geotag_country           'geotag_country LIKE '
    LIKE
--------------------------------------------------------------------------------
    $                        before an optional \n, and the end of
                             the string
--------------------------------------------------------------------------------
    1                        '1'
--------------------------------------------------------------------------------
  )                        end of \5

Next, you need to provide full SQL query example after preg_replace .

If we can have the full SQL query, we may also understand the customization.

Looking at what you wrote we need to have the arguments you set for the WP_Query, to understand how you organized the query.

More, CONCAT is not a smart thing in there, it forces MySQL to concatenate strings — a slow down factor.

Hope this may be helpful.

Related Posts:

  1. How to modify posts_where filter only for the search query
  2. Search with filters and title
  3. Search pre_get_posts filter which can handle multiple post types and categories?
  4. Filter keywords from search query
  5. Ignore dots when searching in the media library?
  6. Search results sorted by post types
  7. Adding id and class to the search input in WordPress search form
  8. How to apply filter at search of woocommerce products?
  9. How to edit dashboard search posts button texts for my CPT?
  10. Filter custom post type using multiple taxonomy dropdowns
  11. Admin Backend – Search Pages only by title
  12. Comment search plugin
  13. Create Search Form to Filter Through Terms
  14. Get Posts updated or published within the last x hours
  15. Run posts_where and posts_join only on the main query
  16. Map plugin with proximity search compatible with Buddypress
  17. How to trim white space in search terms?
  18. conditional search
  19. How to set a filter search for categories of blog posts in wordpress
  20. Custom SQL query slows down when using multiple OR … LIKE … in posts_where filter
  21. Customising the default wordpress search functionality
  22. Search with filters
  23. Modify WordPress search behaviour in backend?
  24. Re-order search results with posts_orderby filter and post meta value
  25. meta box loop problem with a search filter
  26. Custom search fields and AJAX support
  27. using posts_where for meta data on pre_get_posts
  28. How we make the filter for fornt end user
  29. Filter and Search
  30. Taxonomy search filters
  31. Filter posts by multiple checkbox categories
  32. Search and Filter Using Custom Post Type, Custom Taxonomy, and Advanced Custom Fields
  33. How to filter users on admin users page by custom meta field?
  34. How can I add an Author filter to the Media Library?
  35. Modify WordPress Rest Api Request/Response
  36. How to add some custom HTML into wordpress admin bar?
  37. Add wrapper to only youtube videos via embed_oembed_html filter function
  38. Hook into admin post list page
  39. Add post/page ID to inserted links within the_content
  40. How to exclude/filter a tag from get_the_tag_list()
  41. Ajax, filters and shortcodes
  42. Filter the blog’s title without using global variables
  43. Multiple Ajax Data Action
  44. Changing a WordPress core function without hacking core
  45. Change WordPress RSS link with filter?
  46. How to remove get_post_metadata using remove_filter inside a class?
  47. where to apply “apply filters” and other Sanitization Functions
  48. Modifying the Search Results
  49. Sorting and limitation with pre_get_posts
  50. Warning: Missing argument 2 for widget_title filter
  51. Change term name only on front
  52. How do I hide the current page’s title?
  53. Change name of existing post status type
  54. add_filter(‘the_content’, ‘…’) stops pagination from working
  55. Header image automatically changes depending on season
  56. How to remove SKU’s from ALL products in Quick View – already remove from each product page
  57. How to hide Ads in between posts on AMP? [closed]
  58. What is the downside of using a filter as a “poor man’s” dependency injection?
  59. BBPress changing default group activity
  60. How can I change the language of automated Mails?
  61. Filter the_content to add something before each element?
  62. Replacing a deprecated filter ‘woocommerce_get_price’ with ‘woocommerce_product_get_price’
  63. How do you get specific tags from the_content?
  64. Filter by category and city for doctors and hospitals in wordpress
  65. Why is overwriting $GLOBALS killing the_content()?
  66. Sorting products by price ( regular + sale price )
  67. Advanced search redirecting to another page then filter further
  68. Create new custom field that calculates age
  69. Remove comments validation (remove filter?)
  70. How to query if meta_key does exist or not?
  71. Remove Site Name from wp_title WITHOUT removing from attribute
  72. Plugin default settings hook
  73. add_filter to the_content after apply_filters
  74. How to filter with dropdown in backend for custom data
  75. Is there any reason for the nested filters to be applied on the first case and not in the second one?
  76. Best practice: Custom Post Type / Filter / Load more
  77. How to Edit Ecommerce filters URL, h1, h2 , Title
  78. Redirect an archive page to its relevant URL-friendly filtered page
  79. Show uploaded pdf files dynamically and filter by month name
  80. how to use substr with get_the_content()
  81. AJAX Post Filter
  82. Mystery line break
  83. How to add markup to the wp-custom-header div
  84. How to take shortcode and content separately from a page?
  85. Display post after choice two taxonomy terms
  86. How to stop echoing gallery inside content?
  87. Having issue with dynamic data within restrict_manage_posts function
  88. how to filter datalist table of wordpress
  89. Ajax Filtering Pagination
  90. Is there a function to edit Blogs contents in Blogs page?
  91. Can’t set properly WordPress add_filter function
  92. Hook inside a hook
  93. Filter WordPress Archive Widget to exclude posts with specific custom taxonomy term id
  94. Adding user filter – Not updating data in URL
  95. filter wptexturize doesn’t work on old posts titles
  96. wp_get_attachment_link filter not working
  97. Getting entry ID from frm_email_message filter in formidable
  98. Is there a hook or filter that adds a button to the left of the search box?
  99. filter a list by gender
  100. How can I conditionally add the filter option_home?