Have noticed that search on partial SKU does not find anything. ie it needs to be full SKU. Can anyone suggest an easy/correct way to alter this? Was thinking of adding '*' to end of search inside the search control but that might be a bit dodgy..
Thanks,
Pat.
Partial SKU search?
Re: Partial SKU search?
If you're using 7.0.3 or greater, then you can use the SQL full text search (turn it on in admin). The full text will only match on SKUs (or anything else) where the search BEGINS with your search term. You can add the * before and after and it will switch to a LIKE search. The problem with the like search is that it will require a full table scan for every search. That can be slow depending on the size of your product table.
What we recently did was add an option to let users search by keyword (full text) or by SKU. For the SkU search we do a LIKE with the wild card on both sides of the search term. Since it is only doing a table scan on the product SKU field it is fast enough.
What we recently did was add an option to let users search by keyword (full text) or by SKU. For the SkU search we do a LIKE with the wild card on both sides of the search term. Since it is only doing a table scan on the product SKU field it is fast enough.
