Need SQL query written
$10-30 USD
货到付款
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! :-)
项目ID: #16319134
关于项目
有25名威客正在参与此工作的竞标,均价$24/小时
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.
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 更多
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.
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
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 更多
Why don’t you use query and assign the value to constant instead of changing on all places
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
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 更多
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..
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 更多
I hello I can do this task.. Once it's done.... You can reward me with the amount and review
I have more than 3.5years of Oracle SQL programming experience. I have a good repo in working tight deadlines with high efficiency.