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"; ?>

MySQL

Project ID: 7170442

About the project

10 proposals

Remote project

Active 9 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@FarazAbbas

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

10 freelancers are bidding on average $81 USD for this job

@coolguyinus2004

i thing you are fixing this query from virtuemart is this the only search query or you have more queries like it to be optimized let me know.

$79 USD in 3 days

4.9

(185 reviews)

7.1

@anamaria1979

Propunerea nu a fost încă furnizată

$66 USD in 0 day

3.0

(11 reviews)

4.5

@nimesh124

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!

$200 USD in 3 days

5.0

(8 reviews)

3.4

@artechnologics

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

$155 USD in 3 days

0.0

(0 reviews)

0.0

@tomjunior

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 .

$111 USD in 2 days

0.0

(0 reviews)

0.0

@mvuherer

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.

$35 USD in 1 day

0.0

(0 reviews)

0.0

@swatiag1101

Hi, I'm a MySQL expert and can optimize the SQL query for you. Looking forward to hearing from. Regards, Swati

$50 USD in 3 days

0.0

(0 reviews)

0.0

@kulisleg

A proposal has not yet been provided

$60 USD in 1 day

0.0

(1 review)

0.0

@Greenlit

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

$55 USD in 1 day