sql
UPDATE ex_user set website= concat("http://",website) where website like "www%";
sql service
Select CONVERT(varchar(100), '2014-'+receive_time, 20) from express_send_old;
sql
UPDATE ex_user set website= concat("http://",website) where website like "www%";
sql service
Select CONVERT(varchar(100), '2014-'+receive_time, 20) from express_send_old;