CODEWITHSUNDEEP
mysqlsql
Vatrose
Vatrose

Reputation: 33

Updating multiple rows in one column in a database

i have a database with the data

enter image description here

i want to edit the column with lab_no and add another zero (0) after the 8 for all the records... how can i do that because the records are many. Thank you

Upvotes: 3

Views: 73

Answers (1)

mikeyq6
mikeyq6

Reputation: 1148

Assuming that all the records begin with EPI8, then you can do this:

UPDATE [tablename] SET lab_no = REPLACE(lab_no, 'EPI8', 'EPI80');

Upvotes: 7

Related Questions