Is this possible?
I want to append the string "-large" to every second row within my products
table, where the column is clean_name
You could use the modulo operator (%
) on an id
column
update products
set clean_name = concat(clean_name, '-large')
where id % 2 = 0