Completed

Need SQL query written

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! :-)

Skills: HTML, Joomla, MySQL, PHP, SQL

See more: basic sql queries pdf, sql query examples from multiple tables, sql statements list, sql queries examples, complex sql query examples, what is sql query, how to run sql query in command prompt, sql query examples with answers, i have a still image with a design i need you to draw it in vector form with correct alignment so we can print it on t-shirt, setup sql query form data, sql query based form input graph results, need sql query, sql query joomla, display sql query joomla, write sql query parent child relation tables database

About the Employer:
( 2 reviews ) Citrus Heights, United States

Project ID: #16319134

Awarded to:

djpeka

Hello there. I'm a programmer and I can write your query without any problem in the next 15 minutes. Cheers

$15 USD in 0 days
(5 Reviews)
3.5

31 freelancers are bidding on average $23 for this job

bdweb

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
(314 Reviews)
7.0
sat12

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
(434 Reviews)
7.0
MimiFL

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 More

$12 USD in 0 days
(189 Reviews)
6.1
jwsolution

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 si More

$25 USD in 1 day
(73 Reviews)
5.9
$25 USD in 1 day
(78 Reviews)
5.4
erskywebsolution

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 possi More

$15 USD in 1 day
(71 Reviews)
4.8
ProfSoftStudio

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
(51 Reviews)
5.3
codingCafe

hi, This is Rahul , i am full stack freelance web developer, i develop joomla modules, components and template. Over the last 2.5 year I have developed the a wide range of websites using open source technologies as More

$15 USD in 1 day
(37 Reviews)
4.7
javierarenas

I can help you with your problem. Please consider my offer. I work with joomla since 2005 so I can write your query

$30 USD in 1 day
(45 Reviews)
4.8
expertatwork

Which database are you using?

$25 USD in 1 day
(42 Reviews)
4.9
itsmfarhan

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 More

$15 USD in 1 day
(9 Reviews)
3.6
Kaki08

A proposal has not yet been provided

$88 USD in 2 days
(19 Reviews)
4.0
vishwakarma09

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
(15 Reviews)
4.1
ahtishamashraf

Why don’t you use query and assign the value to constant instead of changing on all places

$20 USD in 1 day
(11 Reviews)
3.3
thewebgurupk

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
(7 Reviews)
2.9
sreenivas2903

A proposal has not yet been provided

$25 USD in 1 day
(2 Reviews)
2.6
alexanderdth

Hello. I am Alex. A PHP and MySQL Developer . I dealt with mysql detabases and queries for a long time now. I am positive I can write the query for you. I am new to freelancer, therefore my reputation is low, but do More

$15 USD in 1 day
(4 Reviews)
2.7
abfreelancec

Please message me I will complete in next couple of hours. Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 8 years and 3 months experience in SQL. Please let me know more detail More

$10 USD in 0 days
(2 Reviews)
2.4
$35 USD in 1 day
(2 Reviews)
2.1
arrudatrk

i am new on freelancer.com and i need complated jobs on my profile with good review, so i bid lowest [login to view URL] is the code you need. Just change TableName , ColmnName , <site base URL>/ parameters and run it. it will More

$10 USD in 1 day
(2 Reviews)
1.4