* 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 li
* 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 c
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 i
