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
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';
Thanks szabizs :)
We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.