Removing filename searches when searching attachments

Approaching this from the SQL is a mistake, and instead a quick search of the official dev docs for filename reveals a filter named wp_allow_query_attachment_by_filename that is set to true by default:

https://developer.wordpress.org/reference/hooks/wp_allow_query_attachment_by_filename/

apply_filters( 'wp_allow_query_attachment_by_filename', bool $allow_query_attachment_by_filename )

Filters whether an attachment query should include filenames or not.

This means you can disable querying filenames with a quick filter like this:

add_filter( 'wp_allow_query_attachment_by_filename', '__return_false' );

Where __return_false is a function built into WordPress to save time writing filters like this.

Related Posts:

  1. Post_count only shows the number of results per page
  2. WP Query where title begins with a specific letter
  3. Search custom taxonomy term by name
  4. Order Search Results Page by meta_value If no Value Return Remaining Results
  5. Tracing the life of a query
  6. Ignore a filter on the media library
  7. Pagination not working for Custom search form & custom result template
  8. Pagination broken when merging search results with additional WP_Query
  9. How to search by title or tags exclusively?
  10. WordPress search exact match
  11. How do I search WordPress by different fields without a plugin?
  12. Multiple keyword search
  13. Using next/previous_posts_link with customised search
  14. WordPress custom search form with pre_get_posts not work
  15. Add custom search results to main WP search [duplicate]
  16. Searching through different categories on different pages code is not working
  17. WP Query search for attachments and their exact title
  18. WP_Query’s “request” SQL Query
  19. Show selected images on top in Media Manager
  20. is_search was called incorrectly
  21. How do I search inside specific taxonomies in WordPress
  22. Modifying the Search Results
  23. How to find exact match for search term in WP_Query? What is the additional string added in LIKE query in WP_Query?
  24. Creating a custom search for a specific post type
  25. Custom Search Result Page displaying only 1 result.
  26. How to loop for every result found in the_content() when using the search query?
  27. showing all search result in one template
  28. Querying on multiple taxonomies pulled from $_GET checkbox array not working?
  29. Is there any advantage of using default WordPress Search instead of creating a custom one?
  30. WP_Query Not Recognizing Taxonomy Parameter in Custom Search
  31. Search pages that are a child of the current page
  32. Include tags in WP_Query
  33. Search for multiple tags?
  34. Custom Search Not Consistent with Results
  35. Editing the default wordpress search
  36. How to use wp_query to post count by search term > group post count by date > convert to json. (ex. result 12-21-2020 – 343)
  37. Multiple Search Terms WP_Query
  38. Extend product search with meta in WooCommerce
  39. WP Query Args – Title or Taxonomy Value
  40. wordpress search word, “hello world” ===> ‘hello+world’ ===> ‘hello’, ‘world’
  41. Query with search and subscribers only output
  42. Search by post id in a specific page then auto-redirect to searched post
  43. Search for “2nd” also returns “22nd” in wp_query
  44. Add filter post_where and passing post_type argument
  45. using pre_get_posts for search results not found
  46. Modify Search Query if original Query gave no results
  47. Include post content of linked posts in search
  48. How do I amend wp_query before it is run/executed?
  49. wp_query search not taking keywords with together for multiple words
  50. Wildcard search in WP Query
  51. Search Page Returns Nothing
  52. Redirect Search to Form When No Product Results Are Found
  53. How to properly use AND / OR in custom search
  54. How to avoid bypass of search bar rules?
  55. Hide products in uncategorized category from search results
  56. Issues with search after added meta_query
  57. How do you determine if a result in a search query is a post or a page?
  58. wp_query show all values
  59. change posts_orderby of the callback wp_query?
  60. How to restrict search on a certain page to only return results against custom taxonomies?
  61. Ignore image urls in wp_query search
  62. Search.php – return number of results but cannot loop through
  63. How to filter a static post page with ajax and $wp_query
  64. $wp_query->found_posts not returning correct value
  65. WordPress search WP_Query to cover multiple post types and their custom fields?
  66. get all images from the wordpress media library with link to the post they are associated with
  67. My combination of ‘post_type’ and ‘tax_query’ not working?
  68. How to prevent WP_Query from filtering on ‘s’ but keep ‘s’ for other purposes?
  69. Add dynamic search to paginated WP_Query
  70. Pagination repeating posts on search results
  71. Multiple WP_Query args combinations according to post type
  72. Filter admin ajax data by url query
  73. Display the search results like the original pages
  74. How to use jQuery validation to set the search bar to accept only a specific input?
  75. Search with WP_Query, but ignore href URLs in anchor tags?
  76. WordPress search page pagination displaying but not functional
  77. Search has query that will return no results
  78. WP Query – Search in title or author_name
  79. Limit default Search query to post_title
  80. Order & Orderby clause not working with custom query
  81. How can I modify standard search query to include also ACF custom fields values?
  82. How to make the default WordPress search return borader results
  83. WordPress WP_Query offset parameter not working with search parameter
  84. WordPress WP_Query Array Custom search via taxonomies
  85. Need help setting up a search form for wordpress [duplicate]
  86. Manipulating a query
  87. Custom search: Search posts but display parent page in results
  88. Query posts by custom fields
  89. Searching in specific custom post type
  90. Search (Custom Form, Custom Search Result)
  91. WP Query Obj: Set value to be unequal | Hide media by admin
  92. Help with showing text when something is entered in my search bar
  93. Filtering product search results using tags
  94. Using ‘meta_query’ with the ‘pre_get_posts()’ hook disables searching for post titles
  95. How does Show Posts based on a keyword search work in WP_Query
  96. Search query alteration not working for meta values
  97. Advanced Search – Is this possible?
  98. How to include custom fields in wordpress search
  99. Extend search query to search meta keys values based on search string
  100. AJAX multiple search boxes not merging with array merge