changing search from "exact" to "like":

rohitsrivastava · Post by **rohitsrivastava** » Sun Feb 15, 2009 11:51 pm

Hi,

I am using "Simple Search" searching control..but this existing search is somethng like
"exact search" i want to convert it with "Like"
changing search from "exact" to "like"....
For Example:- i want to search product "charm gold swirl wings" it would only show up on a search of the word "gold" or "wing" separately , but not gold wing...
what we have to do for applying this functionality ....
is it possible or not?
your help will highly appreciable....
Thanks in advanced.....

Regards
Rohit

Post by **mazhar** » Mon Feb 16, 2009 5:51 am

Simple search is based on like. Make use of wild card characters for this purpose for example use *gold* to search word gold in any where in string.

blackstonemedia · Post by **blackstonemedia** » Fri Mar 20, 2009 5:34 pm

mazhar wrote:Simple search is based on like. Make use of wild card characters for this purpose for example use *gold* to search word gold in any where in string.

Customers are not going to enter *. How can we modify the simple search to do what the OP is asking?

Post by **mazhar** » Sat Mar 21, 2009 1:34 am

The other possible solution could be to write your custom search component to replace the standard one.

Mike718NY · Post by **Mike718NY** » Sat Mar 21, 2009 9:51 am

I was told the next release of AC7 is going to offer
Microsoft Full Text Search as an option.
Full Text search is great. I used it on another ecommerce website I wrote.
It returns the most relevant searches to the top
(I achieved that by tweaking the SQL in the stored procedure).
It also searches by word inflections (different forms of the same word).
If you search "women" it will also return results for "Women's ".

I believe the search on a website is the most important feature
to have for an ecommerce store. I was checking the shopping cart
table in the database and about 70% of those items were added there from Searches.
If a customer can't find what they want fast, they leave.

blackstonemedia · Post by **blackstonemedia** » Sat Mar 21, 2009 12:27 pm

mazhar wrote:The other possible solution could be to write your custom search component to replace the standard one.

I don't understand how this is an acceptable answer. This is supposed to be a fully featured, top-of-the-line ecommerce application but the search, to be honest, sucks.

AbleCommerce Shopping Cart Software

changing search from "exact" to "like":

changing search from "exact" to "like":

Re: changing search from "exact" to "like":

Re: changing search from "exact" to "like":

Re: changing search from "exact" to "like":

Re: changing search from "exact" to "like":

Re: changing search from "exact" to "like":