Can any one guide me as I what a query in SQL that change all 'a' in string to 'b' in first_name column in name table. Here is my columns name: first_name | list_name
sathishnadu
0
Newbie Poster
Recommended Answers
Jump to PostPlease reffer to this.
UPDATE name SET first_name = REPLACE (first_name, 'a', 'b') WHERE blabla LIKE '%blabla%'; OR UPDATE name SET first_name = REPLACE (first_name, 'a', 'b') WHERE blabla = 'blabla';
All 2 Replies
Szabi Zsoldos
26
Learner and helper guy
Please reffer to this.
UPDATE name SET first_name = REPLACE (first_name, 'a', 'b') WHERE blabla LIKE '%blabla%';
OR
UPDATE name SET first_name = REPLACE (first_name, 'a', 'b') WHERE blabla = 'blabla';
sathishnadu
0
Newbie Poster
Thanks szabizs :)
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.