Find Jobs
Hire Freelancers

Create an MYSQL Custom Query

$10-30 USD

In Progress
Posted about 8 years ago

$10-30 USD

Paid on delivery
We need to create an single custom mysql query, to sort fields like this in an list: (I'm using CB for Joomla, but in this case its an regular standart MYSQL query, this is an dummy example, i will provide the correct tables names and other info necessary to complete work) All data its in same table... 1 - Show first user that status = single and sort it by User ID number 2 - After show users from item 1, show users that interest = soccer ,sorted by user ID again 3 - After show users from item 2, show users that social_netword = facebook, sorted again by User ID
Project ID: 9905221

About the project

15 proposals
Remote project
Active 8 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
I can do it in the least rate and in less than an hour. I have 10 years of experience in MySQL database development. I can help you with other MySQL stuff as well, if required. Money is not the reason I am interested in this, I need good rating.
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
15 freelancers are bidding on average $19 USD for this job
User Avatar
Well, not sure where catch is :-) but this is something like: Select UserID, 1, Other info From Users Where status = single UNION Select UserID,2, Other info From Users Where Status <> single and interest = soccer UNION Select UserID, 3, Other info From Users Where Status <> single and interest <> soccer and netword = facebook Order by 1, 2
$15 USD in 1 day
5.0 (31 reviews)
5.1
5.1
User Avatar
Hi I'm priyan from Sri Lanka. We are 5 friends group working on freelancer with technical knowledge. We can do your job . We have done many projects those can be seen on our profile with great reviews.   We lookingfoward to work for you. Thanks
$15 USD in 1 day
5.0 (21 reviews)
4.4
4.4
User Avatar
Hi, I know what you're after. Contact me to get started. Kind regards, Mirza Suljić
$30 USD in 1 day
5.0 (5 reviews)
3.4
3.4
User Avatar
Hi I have 3+ experience in web development. I did many job like this. I have strong knowledge of Mysql, Oracle, Database Design and I have also strong knowledge in languages like Java, JSP, PHP, Bootstrap CSS, Ajgular JS, HTML, CSS, JQuery etc .
$25 USD in 1 day
4.9 (3 reviews)
2.5
2.5
User Avatar
Easy task. Im ready to do it in a low time. Please provide me more info or script with table strucuture and some data. regards
$25 USD in 1 day
5.0 (2 reviews)
2.5
2.5
User Avatar
Hire Me for best optimised query.
$25 USD in 1 day
5.0 (4 reviews)
2.4
2.4
User Avatar
Hello, I am a systems analyst with 16 years of experience. I have designed many complicated SQL queries involving dozens of tables and strange sorting requirements. Thank you for considering me and have a great day!
$20 USD in 1 day
5.0 (1 review)
0.5
0.5
User Avatar
Hi, I am expert in Web Development. I have more than 6 years of working experience in Web Development. I have good knowledge about the following skills: - PHP - MySQL - HTML - CSS - Javascript - JQuery You are warm welcome to contact me to discuss for further project details. With Thanks and Regards Prafulo
$10 USD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I am a PHP Programmer. I can write for you the query! I really interested with this job. I can accept this job with a lowest wage among other applicants. As I want to earn some pocket money for my coming trip! I would really appreciate if you could hire me! Thank you so much!
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of BRAZIL
Belo Horizonte, Brazil
5.0
43
Payment method verified
Member since Sep 3, 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.