how to limit the search to exact word

Hello Diana

Did you have any luck?

I have it setup to search postcodes but if i put in DE1 it will always bring up the DE11 page

I think this plugin may no longer be supported. No one is responding.

@hdpixeldesign

Hi!

Sorry, I haven’t had the chance to look further into it. ?? What do you mean by postcodes?

postcodes are added to the pages as tags.

for example

DE1
DE11

if you put in DE1 or DE11it will always bring back the DE11 page.

I have since edited some code i found online and created a function to extend the wordpress search to match the tags exactly but thank you anyway.

Might be an idea to look into this for your next release.

any questions just ask,
Hope all is well your end

@hdpixeldesign

Ah I see! Can you please share with me that code you found online? I’ll try to tweak it myself. And does this mean you’re not using the plugin anymore?

Thank you!

i have removed a lot of the original as it was searcing titles, content, comments and tages but this is what i have left,

I can try and find out the original source for you

function my_smart_search( $search, &$wp_query ) {
    global $wpdb;

    if ( empty( $search ))
        return $search;

    $terms = $wp_query->query_vars[ 's' ];
    $exploded = explode( ' ', $terms );
    if( $exploded === FALSE || count( $exploded ) == 0 )
        $exploded = array( 0 => $terms );

    $search = '';
    foreach( $exploded as $tag ) {
        $search .= " AND (
            (wp_hdpd_posts.post_title LIKE '%$tag%')
            OR (wp_hdpd_posts.post_content LIKE '%$tag%')

            OR EXISTS
            (
                SELECT * FROM wp_hdpd_terms
                INNER JOIN wp_hdpd_term_taxonomy
                    ON wp_hdpd_term_taxonomy.term_id = wp_hdpd_terms.term_id
                INNER JOIN wp_hdpd_term_relationships
                    ON wp_hdpd_term_relationships.term_taxonomy_id = wp_hdpd_term_taxonomy.term_taxonomy_id
                WHERE taxonomy = 'post_tag'
                    AND wp_hdpd_term_relationships.object_id = wp_hdpd_posts.ID
                    AND wp_hdpd_terms.name REGEXP '[[:<:]]{$tag}[[:>:]]'
            )
        )";
    }

    return $search;
}

add_filter( 'posts_search', 'my_smart_search', 500, 2 );

didnt take me long

original source

Thank you so much!!

Hey Diana & hdpixeldesgin,

my apologies to both of you for taking this long to respond and even now all I can say is that I am glad to hear you have figured it out.

Once again sorry for not being of any help, take care and have an amazing day,
Petra

Hello PetraP

Not to worry, hope all is well your end.

@petrap

Hi, it’s fine don’t worry about it! Have a great day as well.

Thanks for getting back to me. We had some set backs on our end but we are up to speed now and if there is anything else you need – let me know, I will gladly help ??