Search inconsistant and not smart

Hi,

I asked to Stiofan to have a look at your question and follow up.

He’s working to improve search right now, so please provide admin credentials so that he can check your data.

He’ll reply after the week end though, cause he’ll be off till Sunday.

Thanks

Doing a search for plural to singular in SQL is very difficult, there is no one way that solves the problem, there are a few hackish ways to do it but they are no efficient for big directories, you will see sites like yelp will add a sort of tag “Bike Rentals” to most of this type of listings, i think in this case it when the listing is not using the plural in the name then a plural should be used as a tag.

I am open to discussion if you think you find a site that does it better.

Thanks,

Stiofan

I take it you mean “THE RENTAL SHACK” listing? This listing has no word “bike” and no word “rentals” in the title..

Below is a example SQL query, we check many things but non of the criteria are met, let me know what else you think we should check and i will tell you why we don’t.

AND ( ( wp_posts.post_title LIKE “bike rentals”
OR ( wp_posts.post_title LIKE “bike”
OR wp_posts.post_title LIKE “bike%”
OR wp_posts.post_title LIKE “% bike%” )
OR ( wp_posts.post_title LIKE “rentals”
OR wp_posts.post_title LIKE “rentals%”
OR wp_posts.post_title LIKE “% rentals%” ))
OR (wp_posts.post_content LIKE “bike rentals”
OR wp_posts.post_content LIKE “bike rentals%”
OR wp_posts.post_content LIKE “% bike rentals%”
OR wp_posts.post_content LIKE “%>bike rentals%”
OR wp_posts.post_content LIKE “% bike rentals%”)

OR (wp_terms.name LIKE “bike rentals”
OR wp_terms.name LIKE “bike rentals%”
OR wp_terms.name LIKE “% bike rentals%”
OR wp_terms.name IN (“bike rentals”)) ) ) )

Thanks,

Stiofan

“wp_terms” are both categories and tags.

OR (wp_terms.name LIKE “bike rentals”
OR wp_terms.name LIKE “bike rentals%”
OR wp_terms.name LIKE “% bike rentals%”
OR wp_terms.name IN (“bike rentals”)) ) ) )

Stiofan

Because it does not split the search term, it only does that for the title, the search for term is exact or begins or ends with (as below) You should give it a tag of “bike rentals”

OR (wp_terms.name LIKE “bike rentals”
OR wp_terms.name LIKE “bike rentals%”
OR wp_terms.name LIKE “% bike rentals%”
OR wp_terms.name IN (“bike rentals”)) ) ) )

Stiofan

I would say that is very correct, if you are searching “bike rentals” bike and bicycle are different words, we know they are the same but a SQL database does not. SO if you were then to just search “rentals” you might return car rentals, suite rentals etc which have no relevance.

Stiofan