News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

VM2 Search module modification

Started by kuba84p, February 24, 2015, 21:55:50 PM

Previous topic - Next topic

kuba84p

Hello
I need to modify search module, but I need some help. I'm using VM 2.6.6

When I enter some string (for example: 44)  to search input in frontend - I have many results, for example: 244,  abc 44, 14490, 212344 etc. But I need results only with whole word 44, for example: 44, abc 44. I'm using default VM search module.

I found good example which I can use:
SELECT *
FROM table
WHERE keywords REGEXP '[[:<:]]rid[[:>:]]'

But my question is: where (in which file) can I modify SQL with Select using for search ?


GJC Web Design

vm admin-> models/product.php .. u will see the queries there
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation