Optimize and fine tuning working MySQL search query
$30-250 USD
Completed
Posted about 9 years ago
$30-250 USD
Paid on delivery
I´m looking for a MySQL specialist to optimize a search query.
I specifically need to fine tune the query so that the results are sorted by relevance. (Sort by results that fit the search string best)
Here is the current MySQL query that I use (based on search input "search test"):
<?php
$query ="(SELECT p.virtuemart_product_id, l.product_name
from #__virtuemart_products p join
#__virtuemart_products_da_dk l
on p.virtuemart_product_id = l.virtuemart_product_id
WHERE concat(product_name,product_s_desc,product_sku) RLIKE 'search' AND concat(product_name,product_s_desc,product_sku) RLIKE 'test' AND
[login to view URL] = '1') LIMIT 25";
?>
Hello there!
I like to do this job.
we need to use wildcards for search string in query, and need to check for every db field.
we need to create query for this so just give me a scenario and i'll return a query.
so let start discussion and start project, and thank you for reading
$80 USD in 0 day
5.0 (4 reviews)
2.8
2.8
10 freelancers are bidding on average $81 USD for this job
Hello,
I am well familiar with MySql and query optimization.
I have over 9 years of development experience and i can do this as per your requirements without any difficulty.
How many queries are there to be optimized?
I am ready to start the work right away!
I look forward to speaking with you further.
Thanks!
Hello Client
I have check your post of Optimize and fine tuning working MySQL search query
Me & My team of certified Php developer & web designer are ready to assist in your given task.
Looking for positive response from you.
Thanks
Ar (CTO)
AR Technologies
I have 10 years experience in systems development and databases . I specialize in MySQL . I manage and develop databases for different Brazilian companies. I am a student of computer science at the best university in Latin America. I can solve your problem with quality and speed .
I may be new on freelancer.com but I do have a lot of experience in queries while working with both Microsoft and Oracle DB technologies.
Will get it done in a nice and elegant way.
Hi,
I'm a Sr Mysql DBA and I have more than 8 years of Mysql experience.
Mysql Optimization is part of my daily job and I'll be happy to help you optimize your query.
Sincerely,
Franck