WordPress.org

Support

Support » How-To and Troubleshooting » Custom Query for Search

Custom Query for Search

  • Hello,

    I am creating a new ajax search functionality in my theme.

    I want to search in a Custom Post Type and the search word should be compared with POST ID, POST NAME, POST SLUG, POST CONTENT, POST EXCERPT and also term of a (fixed) texonomy.

    The Custom Post Type is “Property”
    The Texonomy is “Locations”

    So I have created a query:

    SELECT * FROM $wpdb->posts
    	INNER JOIN $wpdb->term_relationships ON($wpdb->posts.ID = $wpdb->term_relationships.object_id)
    	INNER JOIN $wpdb->terms ON($wpdb->term_relationships.term_taxonomy_id = $wpdb->terms.term_id)
    	WHERE 
    
    	$wpdb->posts.post_status = 'publish'
    	AND $wpdb->posts.post_type = 'properties'
    	AND (
    	$wpdb->terms.name LIKE '%$q%'
    	OR $wpdb->posts.ID LIKE '$q'
    	OR $wpdb->posts.post_content LIKE '%$q%'
    	OR $wpdb->posts.post_title LIKE '%$q%'
    	OR $wpdb->posts.post_excerpt LIKE '%$q%'
    	OR $wpdb->posts.post_name LIKE '%$q%'
    	)
    
    	AND $wpdb->posts.post_status = 'publish'

    This is working but the result is list is repeating properties.
    So anyone help me to correct this query?

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Custom Query for Search’ is closed to new replies.
Skip to toolbar