Find Jobs
Hire Freelancers

DB search - sort by relevance

$30-250 USD

已取消
已发布将近 14 年前

$30-250 USD

货到付款
We have a MySQL InnoDB table in our database where we want to perform searches on a single field (text). Upon search, the search results must be outputted to the client sorted (descending) by relevance, based on how many occurrences the search term have in each recordset of the field in question. The user will then be able to change the sorting to sort by date (descending). The search must be able to use the LIKE parameter, and calculation of number of occurrences must also be counted towards the LIKE parameter. The search must be available to client in the following three ways; all words, some words, exact match, meaning that there will be needed three different types of SQLs, one for each search method. Changing the table to MyISAM is not an option, and the technique developed must be easy to clone to other table searches. The website where the search should be available, is PHP (Symfony, Doctrine platform). Code must comply to PHP.
项目 ID: 683752

关于此项目

7提案
远程项目
活跃14 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
7 freelancers are bidding on average $179 USD for this job
用户头像
The project will be completed within few hours. Please check PMB for more details. Best Regards
$100 USD 在2天之内
4.9 (101条评论)
6.3
6.3
用户头像
I can help you, please check your PMB.
$100 USD 在3天之内
5.0 (6条评论)
3.6
3.6
用户头像
I have done similar job.. plz check the PMB for further details!!!
$350 USD 在10天之内
0.0 (0条评论)
0.0
0.0
用户头像
Hi, I' ve done similar job before so I have code (php classes) that I could reuse in order to build your functionality. My area of expertise is oop PHP and mysql databases. I guarantee that functions will be easy to integrate with your current application.
$100 USD 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
I am readyto start rigth now.
$250 USD 在10天之内
0.0 (1条评论)
0.0
0.0
用户头像
We are happy to start on this immediately and are PMing you our initial thoughts on your problem.
$100 USD 在6天之内
0.0 (0条评论)
0.0
0.0

关于客户

PAKISTAN的国旗
karachi, Pakistan
4.8
82
付款方式已验证
会员自5月 28, 2007起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。