I have a database of products named with three letters a space and then 5 numbers i.e.:
abc 12345 abd 23456 abc 34567 ... ...
I want to get rid of that space in between, and I just don't know how 🙁
removing 300000 by hand would take to long...
Javi
UPDATE products SET code = CONCAT(LEFT(code,3), RIGHT(code,4))
BEWARE - Are there related tables which will give a problem if the code is changed?
hth
