Update every entry with litte change

[Anon]

Hi,

there's a field in my table named "tel"!
I want to add a zero in front of every entry and insert a "-" at third position! But I cant figure out how to query that. Help...

Thx!

[brandonschnell]

try:

update table tel set field_name = concat("0",substring(field_name,1,2),"-",substring(field_name,3));

http://www.mysql.com/doc/S/t/String_functions.html