Find Jobs
Hire Freelancers

Need SQL query written

$10-30 USD

In Progress
Posted about 6 years ago

$10-30 USD

Paid on delivery
I have a Joomla site that has a bunch of absolute URLs in the images which I need changed to relative. They're currently in the form <site base URL>/image/xxxxx. I need the <site base URL>/ removed and the simplest way is to run an SQL query. 'Cept I can't write it! :-)
Project ID: 16319134

About the project

24 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
24 freelancers are bidding on average $24 USD for this job
User Avatar
Hi, i will remove all the base urls.. I am Joomla,PHP programmer having 5 years of experience. I am very good in wordpress,php,mysql,joomla. I have done highest projects here in Joomla.
$25 USD in 1 day
4.8 (647 reviews)
7.5
7.5
User Avatar
Hi, i m serious freelancer with 100% completion rate and i believe i can help you create UPDATE query in matter of minutes. I've done hundreds of SQL projects and i've never had a single problem. If you are interested please message me. Thanks, Milan
$12 USD in 0 day
5.0 (400 reviews)
7.0
7.0
User Avatar
Hello sir, so you means in image path with external site url store in DB. so you want to run sql query and remove those site url and remain relative path of site right? in that case i just want to confirm those site url are of current site or other external site? if external site then those relative path are exist in our site ? Please come for chat to clear this so as per we go ahead. Thanks.
$25 USD in 1 day
5.0 (143 reviews)
7.2
7.2
User Avatar
I am available for long term and interested to work for you for a long time if you allow. For further detail we may discuss over message board.
$30 USD in 1 day
4.8 (330 reviews)
7.1
7.1
User Avatar
Cept I can't write it! Dear Sir! I make SQL query written ++ This is my job. I'm ready to begin now. Pm for me. Please check my reviews and profile https://www.freelancer.com/u/ProfSoftStudio.html
$55 USD in 1 day
4.8 (93 reviews)
6.0
6.0
User Avatar
Which database are you using?
$25 USD in 1 day
4.9 (48 reviews)
5.1
5.1
User Avatar
we have very good experience developer i am sure we will give you our best for you task. you can see my profile feedback from clinet. i hope you give me reply for discuss the project and i will start as soon as possible.
$15 USD in 1 day
5.0 (86 reviews)
5.2
5.2
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
4.8 (18 reviews)
4.5
4.5
User Avatar
A proposal has not yet been provided
$88 USD in 2 days
4.2 (25 reviews)
4.6
4.6
User Avatar
Why don’t you use query and assign the value to constant instead of changing on all places
$20 USD in 1 day
4.6 (16 reviews)
4.4
4.4
User Avatar
the query is update table set column=substr(column, 10,length(column)-10) where 10 is length of site url note; take table backup before executing
$15 USD in 1 day
4.7 (17 reviews)
4.1
4.1
User Avatar
Hello, I have simple way for this as I am skilled and experienced web developer.I have 10+ years of work experience , my expertise are PHP, MYSQL, WORDPRESS,WOOCOMMERECE,JOOMLA,LARAVEL,,CODEINGITER, OPEN CART, CUSTOM CMS,GIT, HTML,JQUERY,AJAX AND CSS. I'd like the opportunity to discuss this job further with you and start immediately if given the chance. Best Regards! Farhan Mahmood
$15 USD in 1 day
5.0 (10 reviews)
3.8
3.8
User Avatar
Provided its one location change and not 100 locations I can do it in less then 5 minutes. I am full time database administrator and writing sql queries is my forte..
$15 USD in 8 days
5.0 (7 reviews)
2.9
2.9
User Avatar
I WILL CHNAGE THE MYSQL QUERY RIGHT AWAY AS PER YOUR REQUIREMENT IN THE SIMPLEST WAY ​​I don't just build websites, rather build your business by crafting visually stunning memorable experiences for web and interfaces. I design, manage and develop custom web apps that suit your need. I develop web and mobile applications to accelerate and excel your future! I always use MySQLi or PDO extension as well as latest PHP 7.x version so that your PHP scripts are up-to-date with the latest versions. I am Dependable & Reliable from start to end even after your website is up and running. Accessible 24*7 through Whatsapp, Skype, Google Hangouts, Facebook Messenger, Email whichever medium of communications you prefer to. Technical partner towards your web success Please inbox me to know your requirements more clearly to proceed
$24 USD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
What DBMS would you like to add to your site? Or do not you care?
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I hello I can do this task.. Once it's done.... You can reward me with the amount and review
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$35 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have more than 3.5years of Oracle SQL programming experience. I have a good repo in working tight deadlines with high efficiency.
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Experienced in complex SQL queries, including XML parsing or string parsing. Good handling of string manipulation functions and efficiency.
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Citrus Heights, United States
5.0
2
Payment method verified
Member since Jun 30, 2010

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.