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:
- Post_count only shows the number of results per page
- WP Query where title begins with a specific letter
- Search custom taxonomy term by name
- Order Search Results Page by meta_value If no Value Return Remaining Results
- Tracing the life of a query
- Ignore a filter on the media library
- Pagination not working for Custom search form & custom result template
- Pagination broken when merging search results with additional WP_Query
- How to search by title or tags exclusively?
- WordPress search exact match
- How do I search WordPress by different fields without a plugin?
- Multiple keyword search
- Using next/previous_posts_link with customised search
- WordPress custom search form with pre_get_posts not work
- Add custom search results to main WP search [duplicate]
- Searching through different categories on different pages code is not working
- WP Query search for attachments and their exact title
- WP_Query’s “request” SQL Query
- Show selected images on top in Media Manager
- is_search was called incorrectly
- How do I search inside specific taxonomies in WordPress
- Modifying the Search Results
- How to find exact match for search term in WP_Query? What is the additional string added in LIKE query in WP_Query?
- Creating a custom search for a specific post type
- Custom Search Result Page displaying only 1 result.
- How to loop for every result found in the_content() when using the search query?
- showing all search result in one template
- Querying on multiple taxonomies pulled from $_GET checkbox array not working?
- Is there any advantage of using default WordPress Search instead of creating a custom one?
- WP_Query Not Recognizing Taxonomy Parameter in Custom Search
- Search pages that are a child of the current page
- Include tags in WP_Query
- Search for multiple tags?
- Custom Search Not Consistent with Results
- Editing the default wordpress search
- 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)
- Multiple Search Terms WP_Query
- Extend product search with meta in WooCommerce
- WP Query Args – Title or Taxonomy Value
- wordpress search word, “hello world” ===> ‘hello+world’ ===> ‘hello’, ‘world’
- Query with search and subscribers only output
- Search by post id in a specific page then auto-redirect to searched post
- Search for “2nd” also returns “22nd” in wp_query
- Add filter post_where and passing post_type argument
- using pre_get_posts for search results not found
- Modify Search Query if original Query gave no results
- Include post content of linked posts in search
- How do I amend wp_query before it is run/executed?
- wp_query search not taking keywords with together for multiple words
- Wildcard search in WP Query
- Search Page Returns Nothing
- Redirect Search to Form When No Product Results Are Found
- How to properly use AND / OR in custom search
- How to avoid bypass of search bar rules?
- Hide products in uncategorized category from search results
- Issues with search after added meta_query
- How do you determine if a result in a search query is a post or a page?
- wp_query show all values
- change posts_orderby of the callback wp_query?
- How to restrict search on a certain page to only return results against custom taxonomies?
- Ignore image urls in wp_query search
- Search.php – return number of results but cannot loop through
- How to filter a static post page with ajax and $wp_query
- $wp_query->found_posts not returning correct value
- WordPress search WP_Query to cover multiple post types and their custom fields?
- get all images from the wordpress media library with link to the post they are associated with
- My combination of ‘post_type’ and ‘tax_query’ not working?
- How to prevent WP_Query from filtering on ‘s’ but keep ‘s’ for other purposes?
- Add dynamic search to paginated WP_Query
- Pagination repeating posts on search results
- Multiple WP_Query args combinations according to post type
- Filter admin ajax data by url query
- Display the search results like the original pages
- How to use jQuery validation to set the search bar to accept only a specific input?
- Search with WP_Query, but ignore href URLs in anchor tags?
- WordPress search page pagination displaying but not functional
- Search has query that will return no results
- WP Query – Search in title or author_name
- Limit default Search query to post_title
- Order & Orderby clause not working with custom query
- How can I modify standard search query to include also ACF custom fields values?
- How to make the default WordPress search return borader results
- WordPress WP_Query offset parameter not working with search parameter
- WordPress WP_Query Array Custom search via taxonomies
- Need help setting up a search form for wordpress [duplicate]
- Manipulating a query
- Custom search: Search posts but display parent page in results
- Query posts by custom fields
- Searching in specific custom post type
- Search (Custom Form, Custom Search Result)
- WP Query Obj: Set value to be unequal | Hide media by admin
- Help with showing text when something is entered in my search bar
- Filtering product search results using tags
- Using ‘meta_query’ with the ‘pre_get_posts()’ hook disables searching for post titles
- How does Show Posts based on a keyword search work in WP_Query
- Search query alteration not working for meta values
- Advanced Search – Is this possible?
- How to include custom fields in wordpress search
- Extend search query to search meta keys values based on search string
- AJAX multiple search boxes not merging with array merge