Find Jobs
Hire Freelancers

MySQL Administrator - Create Query

$10-30 AUD

En curso
Publicado hace más de 5 años

$10-30 AUD

Pagado a la entrega
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 del proyecto: 18257678

Información sobre el proyecto

14 propuestas
Proyecto remoto
Activo hace 5 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
'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 en 0 día
4,9 (218 comentarios)
7,2
7,2
14 freelancers están ofertando un promedio de $30 AUD por este trabajo
Avatar del usuario
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 en 1 día
5,0 (807 comentarios)
8,2
8,2
Avatar del usuario
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 en 0 día
4,9 (319 comentarios)
7,8
7,8
Avatar del usuario
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 en 1 día
5,0 (337 comentarios)
7,1
7,1
Avatar del usuario
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 en 1 día
5,0 (124 comentarios)
6,5
6,5
Avatar del usuario
2018-11-29 sir message me i am mysql/php expert ... 2018-11-29 sir message me i am mysql/php expert ...
$30 AUD en 0 día
5,0 (176 comentarios)
6,3
6,3
Avatar del usuario
"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 en 1 día
5,0 (18 comentarios)
5,0
5,0
Avatar del usuario
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 en 1 día
5,0 (46 comentarios)
5,0
5,0
Avatar del usuario
Hello there, I can help with this query. We can discuss about it. And lets do it. Thanks.......................
$55 AUD en 1 día
5,0 (19 comentarios)
4,4
4,4
Avatar del usuario
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 en 1 día
5,0 (2 comentarios)
2,1
2,1
Avatar del usuario
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 en 7 días
5,0 (2 comentarios)
0,5
0,5
Avatar del usuario
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 en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
Melbourne, Australia
4,9
70
Forma de pago verificada
Miembro desde ene 15, 2012

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.