Hi All, I am trying to do an update on a mysql table where I have some rows of data that need to be fixed. The data in one column was entered as '01000xxx' and is a
String value. I want to change all rows that have a column which begins with '01000' to be '01111'. So, for example, a value of 01000abc would be updated to be 01111abc.
Here is what I am trying but I am getting a SQL Error.
update lightpaktable set serialNumber = '0111'+RIGHT(serialNumber,4) where serialnumber like '01000e%'
I have also tried
update lightpaktable set left(serialNumber,4) = '0111' where serialnumber like '01000e%'
Any idea's ?