Find Jobs
Hire Freelancers

Fix sql statement

$10-30 USD

Closed
Posted over 6 years ago

$10-30 USD

Paid on delivery
I need someone to help me fix this sql statement. $query=mysqli_query($conn,"select * from tbl_songs where song_originalname LIKE '%track%' AND where song_originalname LIKE 'unknow%'");
Project ID: 15901207

About the project

55 proposals
Remote project
Active 6 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
55 freelancers are bidding on average $18 USD for this job
User Avatar
Hi, I'm interested to work on your project, I will start project immediately Please let me know if you require any detailed information. Waiting for your reply Thanks Dev
$35 USD in 1 day
5.0 (473 reviews)
7.7
7.7
User Avatar
Hello Sir, we have rich experience in sql query development. I am really interested in your application so i have placed a fair price. i don't want any upfront payment. 100% once job done. I am 100% sure i can do this. Also dont worry about time frame i will try to complete within 30 mins max. Please consider my bid .Please let me know what do you think. Also you can see my profile about my work and communication. Thank you
$14 USD in 0 day
5.0 (95 reviews)
7.8
7.8
User Avatar
A proposal has not yet been provided
$15 USD in 1 day
4.9 (209 reviews)
7.2
7.2
User Avatar
I have four years experience as a web developer will fix your issue inbox me we can discuss more over chat.
$10 USD in 0 day
5.0 (167 reviews)
6.6
6.6
User Avatar
Hi You have a repeated where clause in the SQL, which is the problem. Please rewrite the SQL as below, and you will be all set. "select * from tbl_songs where song_originalname LIKE '%track%' AND song_originalname LIKE 'unknow%'" Please accept the award the project and pay me $10 if this works for you. Thanks Roni
$10 USD in 1 day
5.0 (96 reviews)
6.7
6.7
User Avatar
Hello, I don't want make you to pay for that, just delete the second where: select * from tbl_songs where song_originalname LIKE '%track%' AND song_originalname LIKE 'unknow%' That's it.
$25 USD in 1 day
5.0 (54 reviews)
6.3
6.3
User Avatar
It is easy work for me I can guide you to fix this in next 20 mins. Available right now for the communication
$15 USD in 0 day
4.8 (167 reviews)
6.4
6.4
User Avatar
Hi there, My name is Manish. I would like to fix your sql query. please get in touch to discuss more. I have good proficiency in sql. Please go through my profile.
$10 USD in 0 day
4.9 (136 reviews)
6.3
6.3
User Avatar
I can help you fix it right away, just let me know what the problem is with it or what it's doing wrong. I'll be available anytime tonight. I'm in the US as well by the way, in Florida
$25 USD in 1 day
4.8 (154 reviews)
6.5
6.5
User Avatar
Hi I will do the changes. I hope you need to if the current displayed query issue. OR, do you want to change the query. I will give you the long time best support. Please check my profile for more details. Thank you.
$19 USD in 0 day
4.9 (65 reviews)
5.8
5.8
User Avatar
I am Krunal, having 12+ years of exp. having completed majority of projects with MS technologies. I have a team of exp. developers expertise in .NET & MS-SQL for developing a web portal / solutions. We can provide you the Query you are looking for. We believe in establishing the long-term relationship with our clients, giving them best services at a reasonable rate. Looking forward to an opportunity to discuss this project with you and work on it.
$25 USD in 0 day
5.0 (34 reviews)
5.7
5.7
User Avatar
use this $query=mysqli_query($conn,"select * from tbl_songs where song_originalname LIKE '%track%' AND song_originalname LIKE 'unknow%'"); no need add where 2 times in query
$15 USD in 1 day
4.9 (45 reviews)
5.5
5.5
User Avatar
Hello, I would like to thank you for posting the project. Please find my proposed solution below: $query=mysqli_query($conn,"select * from tbl_songs where song_originalname LIKE '%track%' AND song_originalname LIKE 'unknow%'"); Thanks.
$10 USD in 1 day
4.9 (24 reviews)
5.0
5.0
User Avatar
I have a 7+ year of experience in sql database managements. And handled many web and window based applications
$10 USD in 0 day
5.0 (5 reviews)
4.2
4.2
User Avatar
Simple remove one extra "where"... $query=mysqli_query($conn,"select * from tbl_songs where song_originalname LIKE '%track%' AND song_originalname LIKE 'unknow%'");
$10 USD in 1 day
5.0 (7 reviews)
3.8
3.8
User Avatar
Hello, i am a php developer and a msc computer science student. i can help you fix your bug in few minutes if you award me the project
$15 USD in 1 day
4.9 (18 reviews)
3.7
3.7
User Avatar
Hello,Hope you doing well.I read your project description,Lets have a technical discussion,negotiate costing, timeline and then we proceed further. I Will show my past work also. Thanks!
$23 USD in 1 day
4.9 (5 reviews)
3.8
3.8
User Avatar
Hi,I'm familiar with SQL, contact me if you wanna fix your project .
$30 USD in 1 day
5.0 (7 reviews)
3.3
3.3
User Avatar
select * from tbl_songs where song_originalname LIKE '%track%' AND song_originalname LIKE 'unknow%'
$10 USD in 1 day
5.0 (6 reviews)
2.2
2.2
User Avatar
Hello! Looks like you would at least need to remove the word "where" right after the "AND" in your statement
$10 USD in 1 day
5.0 (3 reviews)
1.9
1.9

About the client

Flag of UNITED STATES
Jonesboro, United States
5.0
2
Member since Dec 15, 2017

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.