Member Avatar for sathishnadu

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

  • 2 Contributors
  • 2 Replies
  • 150 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by sathishnadu
Member Avatar for Szabi Zsoldos

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';
Edited by Szabi Zsoldos
Member Avatar for sathishnadu

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.