Update database without get actual contain
Posted on 2009-06-28
Hi E's, in one field of my mysql database, I have this format nn nn nn, in practice like this, 05 44 99, 2 numeric, space, 2 numeric, space, 2 numeric.
Every time I have a value that was more bigger then one of the values in database, I need to upgrade the database (ex. If I have the new value '55', I need to remove 05 and return for the first place the number '44', becomes 44 55 99).
I can do that in this way:
explode string to get 3 arrays
verify if new value is more bigger then the low number in database, if yes replace and restructure all array
implode the array to string
This is the best way to do this?
Have any simple way to do this?