Hi all,
Me needs to change the format of some telephone numbers which are placed in
a mysql database.
Current format: 49xyz
Wanted format: 0xyz
Now i know how to remove the leading 49:
UPDATE table SET field=(TRIM(LEADING '49' FROM field));
But how can i replace the 49 with a 0?
Or maybe in 2
* Bernd Tannenbaum
Me needs to change the format of some telephone numbers which are
placed in a mysql database.
Current format: 49xyz
Wanted format:0xyz
Now i know how to remove the leading 49:
UPDATE table SET field=(TRIM(LEADING '49' FROM field));
But how can i
* Roger Baklund
UPDATE table SET field=CONCAT(0,TRIM(LEADING '49' FROM field));
.. and this will of course prefix _all_ numbers with a '0', not only those
that started with '49'... you should append WHERE field LIKE '49%' to you
update statement.
--
Roger
--
MySQL General Mailing List
For