Need SQL query written

进行中 已发布的 6 年前 货到付款
进行中 货到付款

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

HTML Joomla MySQL PHP SQL

项目ID: #16319134

关于项目

25个方案 远程项目 活跃的6 年前

有25名威客正在参与此工作的竞标,均价$24/小时

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.

$25USD 在1天里
(636条评论)
7.5
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 更多

$12 USD 在0天内
(383条评论)
7.0
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 更多

$25USD 在1天里
(140条评论)
7.2
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.

$30USD 在1天里
(327条评论)
7.1
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

$55USD 在1天里
(93条评论)
6.0
expertatwork

Which database are you using?

$25USD 在1天里
(48条评论)
5.1
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 更多

$15USD 在1天里
(85条评论)
5.2
Kaki08

A proposal has not yet been provided

$88 USD 在2天内
(24条评论)
4.5
sreenivas2903

A proposal has not yet been provided

$25USD 在1天里
(18条评论)
4.5
ahtishamashraf

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

$20USD 在1天里
(16条评论)
4.4
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

$15USD 在1天里
(17条评论)
4.1
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 更多

$15USD 在1天里
(10条评论)
3.8
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 在8天内
(7条评论)
2.9
phpladders

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 interfac 更多

$24 USD 在0天内
(0条评论)
0.0
palgeresi

A proposal has not yet been provided

$25USD 在1天里
(0条评论)
0.0
denipotapov

May be done in a 3 days maximum. Not only can sql be used.

$20 USD 在3天内
(0条评论)
0.0
IvanKuznetcov

What DBMS would you like to add to your site? Or do not you care?

$15USD 在1天里
(0条评论)
0.0
shridharshridhar

I hello I can do this task.. Once it's done.... You can reward me with the amount and review

$15USD 在1天里
(0条评论)
0.0
ankitvora03

A proposal has not yet been provided

$35 USD 在3天内
(0条评论)
0.0
hmntmhnt

I have more than 3.5years of Oracle SQL programming experience. I have a good repo in working tight deadlines with high efficiency.

$20USD 在1天里
(0条评论)
0.0