Find Jobs
Hire Freelancers

MySQL Administrator - Create Query

$10-30 AUD

In Progress
Posted over 5 years ago

$10-30 AUD

Paid on delivery
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.
Project ID: 18257678

About the project

14 proposals
Remote project
Active 5 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
'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 in 0 day
4.9 (218 reviews)
7.2
7.2
14 freelancers are bidding on average $30 AUD for this job
User Avatar
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 in 1 day
5.0 (807 reviews)
8.2
8.2
User Avatar
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 in 0 day
4.9 (319 reviews)
7.8
7.8
User Avatar
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 in 1 day
5.0 (337 reviews)
7.1
7.1
User Avatar
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 in 1 day
5.0 (124 reviews)
6.5
6.5
User Avatar
2018-11-29 sir message me i am mysql/php expert ... 2018-11-29 sir message me i am mysql/php expert ...
$30 AUD in 0 day
5.0 (176 reviews)
6.3
6.3
User Avatar
"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 in 1 day
5.0 (18 reviews)
5.0
5.0
User Avatar
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 in 1 day
5.0 (46 reviews)
5.0
5.0
User Avatar
Hello there, I can help with this query. We can discuss about it. And lets do it. Thanks.......................
$55 AUD in 1 day
5.0 (19 reviews)
4.4
4.4
User Avatar
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 in 1 day
5.0 (2 reviews)
2.1
2.1
User Avatar
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 in 7 days
5.0 (2 reviews)
0.5
0.5
User Avatar
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 in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Melbourne, Australia
4.9
70
Payment method verified
Member since Jan 15, 2012

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.