Find Jobs
Hire Freelancers

MySQL Search Query

$30-50 USD

Completed
Posted over 11 years ago

$30-50 USD

Paid on delivery
See attached Excel spreadsheet. We are building a web application and are including a SEARCH function. This search must take the search term (which can contain multiple words) and search across multiple columns to find matching results. The attached excel spreadsheet contains table structure, sample data, search terms, and expected results. If you can do this in MySQL with one statement then great otherwise please build a simple PHP app. We can build the PHP but do not have time to focus on the MySQL as we are focused on other areas of our site. Bonus but not necessary: If there is a way to do a "Did you mean" when there are no results, but can offer up similar search terms that would be a cool feature to have. May have more small features like this in the future so hoping to find freelancer that can go above and beyond.
Project ID: 4144253

About the project

13 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

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:
User Avatar
Hi, experienced Web Developer. Kindly check PMB. Regards
$30 USD in 0 day
5.0 (200 reviews)
6.7
6.7
13 freelancers are bidding on average $48 USD for this job
User Avatar
Hi, I can start the work immediately I have checked the excel and this can be done with a simple MYSQL query. let me know if we could start working on this.
$40 USD in 2 days
4.9 (158 reviews)
6.3
6.3
User Avatar
Hello, Contrary to what velsoftconsult is saying, searching a mysql DB is not that simple, and while you can replicate the results in one simple query (especially if you change the tables to MyISAM), you don't want that solution on a moderately busy site. Ideally, I would use a precompiled search function, implementing the Levenshtein algorithm to get the results. Another way to do it would be to use specialized software (there are free options that are REALLY good at this). Unfortunately, within your budget these are far from being doable. So: What I would do, is find you the fastest alternative to using %keyword%. I assume this would involve some PHP at least to separate the words and find the brand by index. (depends on the site of your DB) The did you also mean can be implemented in 2 (straightforward) ways: either using pspell, or Levenshtein (again) with an English dictionary.
$50 USD in 1 day
4.9 (65 reviews)
6.0
6.0
User Avatar
Ready to get started right away.
$80 USD in 1 day
4.9 (107 reviews)
5.8
5.8
User Avatar
Hello sir I have done the similar tasks in a couple of times in my past project. I can assure you of quality service from my side. Lets Start!! Regards PHPYOUTH
$99 USD in 7 days
4.9 (47 reviews)
5.7
5.7
User Avatar
Hello, Please check your PM. Thank you.
$30 USD in 0 day
5.0 (35 reviews)
5.5
5.5
User Avatar
Will the word be searched individually? E.g. searching "Richard Nixon" will search for Richard and Nixon? Looking forward hearing from you.
$50 USD in 0 day
5.0 (41 reviews)
5.5
5.5
User Avatar
Hi, I know what to do. Please award your project to me so that I can start. Thanks.
$50 USD in 2 days
5.0 (17 reviews)
5.3
5.3
User Avatar
Hi, I can give you an efficient search using special technique over all fields.
$50 USD in 7 days
5.0 (48 reviews)
4.9
4.9
User Avatar
Hi, I can do it perfectly. I have rich experiences on this fields. Best regards.
$50 USD in 1 day
5.0 (22 reviews)
4.4
4.4
User Avatar
Hi, I can help you on this
$35 USD in 1 day
3.7 (15 reviews)
3.8
3.8
User Avatar
Dear Employer, MySQL expert is here for your requirement. ThanksD
$35 USD in 1 day
4.8 (9 reviews)
3.1
3.1
User Avatar
We are database experts...
$50 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
let me do it for you.
$30 USD in 0 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Fairfax, United States
5.0
15
Payment method verified
Member since Apr 23, 2005

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.