Find Jobs
Hire Freelancers

MySQL Administrator - Create Query

$10-30 AUD

进行中
已发布超过 5 年前

$10-30 AUD

货到付款
I am looking to create a query the links two columns in the same table and considers them as a single row when running the query. This needs to ensure that column 1 ('action') and column 2 (availability_date) both equal the value listed. We have multiple entries where 'user_id' in this database table, which has matches for the action and availability_date, but need a query that shows where that specific row has both results ('anytime' and '2018-11-29'). Query follows the below... Show 'user_id' where... [login to view URL] = 'Anytime' AND t1.availability_date='2018-11-29' - consider the above as a single row. As an example, I have 1,000 users who have the date in this database table and 'Anytime' for a different date - but my query returns them still cause it's finding a match - just not linking the action and availability in the same row. Please write the date included above in your response to confirm you have read the brief.
项目 ID: 18257678

关于此项目

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

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
'2018-11-29' Hello, As an expert in SQL, i am very much interested to fix the issue you are having in your current query. I am available to work right now. Looking forward to have a positive response from you. Thanks
$19 AUD 在0天之内
4.9 (218条评论)
7.2
7.2
14威客以平均价$30 AUD来参与此工作竞价
用户头像
2018-11-29 - hello, if you give me phpmyadmin access, I can try to create sql query for you. It seems not hard.
$20 AUD 在1天之内
5.0 (807条评论)
8.2
8.2
用户头像
2018-11-29 More then 5+ years of experience in Development . Also kindly check our profile we have done over 250 project here on freelancer so very much reliable & fit for your project . Kindly initiate chat.
$50 AUD 在0天之内
4.9 (319条评论)
7.8
7.8
用户头像
29-11-18 I am experienced php developer and web designer with the depth knowledge related to MySQL,Laravel,WordPress,MSSQL,JSON,JAVASCRIPT,AJAX,XML,jQuery,CSS,HTML5,Material Designing with the integration of web technologies. I have worked as Php & Web developer in industry and now i am full time freelancer and having the experience of huge and live projects. I can design the web pages with the backend of php and I have also experience of query optimization and pBudget would be 70$erformance management through php support. I am finding one startup like you so i can provide my skills to IT market and I can give you 100% surity for quality work in minimum time sir. I have also launched eCommerce Product for pharmacy industry and launched android app on play store as well , I have great control in android with backend of php webservices and api generation with JSON integration. I can work at anytime with the great satisfactions,quality output and result in your hand with the fulfilling your requirements for sure. Waiting for your positive response , so we can start the work soon ...
$25 AUD 在1天之内
5.0 (337条评论)
7.1
7.1
用户头像
Dear Hiring Manager, We can help you in the project. I am good in: php, codeigniter, laravel, jquery, google map api, MySQL. Let me know when we can discuss in more details and start working on it asap. Looking forward for your response. Thanks.
$30 AUD 在1天之内
5.0 (124条评论)
6.5
6.5
用户头像
2018-11-29 sir message me i am mysql/php expert ... 2018-11-29 sir message me i am mysql/php expert ...
$30 AUD 在0天之内
5.0 (176条评论)
6.3
6.3
用户头像
"29-11-2018" I am a PHP Database Expert and I will a query the links two columns in the same table and considers them as a single row when running the query as per given requirement. Let me know when you are available to take this conversation to next level. Assure standard work within your cost & time. Waiting for your valuable response. Thanks
$25 AUD 在1天之内
5.0 (18条评论)
5.0
5.0
用户头像
Hello there, Hope you are doing well !! I CAN CREATE THIS MYSQL QUERY It's straight to your referenced post I am an expert in MYSQL and having good experience over it.I can do it very well. I'm interested in your project. Please send me a message so that we can discuss more. Looking forward to hear more from you for any query. Sincerely, Ashish Sr. Developer
$20 AUD 在1天之内
5.0 (46条评论)
5.0
5.0
用户头像
Hello there, I can help with this query. We can discuss about it. And lets do it. Thanks.......................
$55 AUD 在1天之内
5.0 (19条评论)
4.4
4.4
用户头像
2018-11-29 Hi, Hope you doing well in your field. I have done similar work before and I am confident enough to complete the project. I have read the requirements thoroughly and understand what you are looking for. Waiting for your response to work with professionals, Warm Regards, Faheem
$50 AUD 在1天之内
5.0 (2条评论)
2.1
2.1
用户头像
Hi there, I'm grateful that you spared a part of your precious time for having a look at my proposal. I expertise in the field which is required in your project and I will deliver complete satisfactory work. I have enough work experience of 4+ years in web development and I guarantee you to deliver my work on time. I'm continuously seeking for good projects here and working hard to make my work history better. So please give me a chance to do this so that I can step forward and gain some good clients on a long-term basis. Please have a word with me over the project so that we can discuss more. I'm looking forward to working with you. I am an experienced and passionate developer. My main areas of expertise are : Angular ASP.NET C# React.js React Native Wordpress Android HTML & CSS Python Node.js Core Java Javascript Website Design • Expert in technologies: Asp.Net MVC, Web API, C#, Entity Framework, LINQ, SQL, and SSRS • Developing highly intuitive & responsive user-interface using HTML5/JS/CSS3, its pre-processors (LESS & SASS), Bootstrap, ReactJS. • OOP's implementation • Cloud services (AWS, Azure) and Server-less architecture. Where, we have worked extensively on MS Azure, Used Azure app services like web apps, API apps, Notification hub, Azure batch processing, Azure AD services, Azure Application Insights, storage services, Azure functions etc. • Used azure active directory for secure login. • API integration (REST & SOAP-based)
$20 AUD 在7天之内
5.0 (2条评论)
0.5
0.5
用户头像
I have read the project description. Before start working, I will need the more project specifications and a look of your MySQL table.
$20 AUD 在2天之内
0.0 (0条评论)
0.0
0.0
用户头像
hello, My name is karthiks and i am experienced and expert in Android, IOS, PHP, MYSQL Wordpress,PHP frameworks. I have read your description and i can easliy work on it. I am new on freelancer and doing this to earn a good review I would love to have the opportunity to discuss your project with you. I am a dedicated developer who delivers projects on time with 100% accuracy. I love to deliver projects with complete customer satisfaction. I also would be able to further discussion on projects with other communication medium. I will always be available to help you.
$25 AUD 在1天之内
0.0 (0条评论)
0.0
0.0

关于客户

AUSTRALIA的国旗
Melbourne, Australia
4.9
70
付款方式已验证
会员自1月 15, 2012起

客户认证

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