Cancelled

sql command

hi there

I am looking for the sql command that allows me to replace text within a field depending on a column value.

eg in the table attached I'd like to change column B value from "30-08-2015 hello" to "30-08-2015 bye" where column A=2 and not affect the rest of the table

Skills: PHP, Software Architecture

See more: verify command sql, sql add field existing table, replace text xml file command line, sql returning text memo field, linux command sql csv, oracle 10g command sql plus download, sql server 200 bcp command sql script, change value text input field javascript, upload sql database command prompt, exporting sql table txt file command line

About the Employer:
( 19 reviews ) Glasgow, United Kingdom

Project ID: #8366343

42 freelancers are bidding on average £15 for this job

rajeshsonisl

Hello! With 98% to 99% completion rate, 800+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page [login to view URL] More

£42 GBP in 1 day
(847 Reviews)
8.4
JulijanAndjelic

Hi there, It's a single line SQL query you're looking for, I can help and explain how to use it if needed. Regards, Julijan

£13 GBP in 0 days
(116 Reviews)
7.2
keshavkalra90

I will make that :) We are skilled PHP developers possess rich experience in PHP/MySQL development & customization clubbed with replete know-how in PHP frameworks such as CakePHP, Zend, and CodeIgniter,WP,JOOMLA,Mage More

£18 GBP in 1 day
(166 Reviews)
7.2
MrMSparrow

A proposal has not yet been provided

£10 GBP in 1 day
(62 Reviews)
6.4
saadrashad

its pretty simple. are you facing any issues? i have 15 years of experience and have done many jobs in sql. i can help you

£18 GBP in 0 days
(136 Reviews)
6.1
zubairuddin

Hi! Being an experienced coder, I can resolve this issue within next hour, if you accept my bid now. So many times in the career of 10 years, have done it. Hope to hear from you soon. Regards.

£18 GBP in 1 day
(62 Reviews)
6.3
isensebd

A proposal has not yet been provided

£20 GBP in 1 day
(84 Reviews)
6.2
avinashjain09

Hello, I have understood your problem, I can resolve this. I have expertise in database, in my profile maximum projects are database related only. Can we have more discussion. I have 4 years of experience in php,mysql, More

£15 GBP in 1 day
(110 Reviews)
6.5
codetod

Hi SQL expert here with 10+ years of DBA experience. Your requirement can be done using a simple REPLACE function and a where condition. Is this MSSQL or MySQL? In either case I can connect to your server on team vi More

£15 GBP in 1 day
(50 Reviews)
6.3
prakashmondal

Hi, I am interested to write sql command to update specific value using another value as per the requirement. Please consider m bid and let me start with the work. Thanks Prakash

£20 GBP in 1 day
(75 Reviews)
6.0
codinglover89

Hi, I'm ready to make sql query for you now this should be very easy task! Thank and Regards Cheers!

£10 GBP in 1 day
(20 Reviews)
6.0
rockingrik

I would like to apply this job, My experience of 5 years in development and my implementation power keeps me one step ahead for working with any web based application with a very high speed. I am pro with PHP, Zend, More

£28 GBP in 1 day
(54 Reviews)
6.0
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a query. I have 7 years’ experience designing and developing databases and dealing with SQL queries. I am highly qualified for this More

£10 GBP in 3 days
(34 Reviews)
5.7
suraj2

Hi, You just want a query or an interface to run this kind of query? .................................................

£20 GBP in 1 day
(44 Reviews)
5.6
kanyan

Hi I am very interested in your project.I want to work with [login to view URL] is a easy task for me so I can do it easily. Please come in chat room for more discussion. I am waiting for you response. Thanks & Regard More

£13 GBP in 1 day
(76 Reviews)
5.6
schungur

Top SQL freelancer... just check my badges

£15 GBP in 1 day
(24 Reviews)
5.7
cgullapalli

HI, I can provide u the querey required. looking forward to work on this project. Plz consider my bid.

£20 GBP in 0 days
(39 Reviews)
5.3
rodweb

Aucune proposition n'a encore été fournie.

£10 GBP in 1 day
(44 Reviews)
5.5
caciocode

Hi, I am a software developer and I have excellent SQL skills. One of my strongest skills is PHP. This is a very simple task

£18 GBP in 1 day
(85 Reviews)
5.5
jperusan

Use this query: UPDATE table_name SET Column B = "30-08-2015 bye" where Column B = "30-08-2015 hello" and Column A = 2; Or maybe you wish to change "hello" to "bye" for all columns where column A = 2? If this is wha More

£10 GBP in 1 day
(33 Reviews)
4.9