REPLACE(str,from_str,to_str) Returns the string str with all occurrences of the string from_str replaced by the string to_str: mysql> SELECT REPLACE('www.mysql.com', 'w', 'Ww'); -> 'WwWwWw.mysql.com'This function is multi-byte safe.
I'll try it! Thank you!
各位兄台: 这个表该如何建? CREATE TABLE `vw_tblabel` ( `ID` varchar(100), `ID_NAME` text, `NAME` varchar(50), `LEVEL` varchar(50), `STANDARD` varchar(100), `REMARK` text, `UPID` varchar(100) ) SELECT ID AS `ID`, REPLACE(`-`,(length(ID)-3)*1)|NAME AS `ID_NAME`, NAME AS `NAME`, LEVEL AS `LEVEL` , STANDARD AS `STANDARD`, REMARK AS `REMARK`, UPID AS `UPID` FROM `tblabel`
Returns the string str with all occurrences of the string from_str replaced by the string to_str:
mysql> SELECT REPLACE('www.mysql.com', 'w', 'Ww');
-> 'WwWwWw.mysql.com'This function is multi-byte safe.
Thank you!
这个表该如何建?
CREATE TABLE `vw_tblabel` (
`ID` varchar(100),
`ID_NAME` text,
`NAME` varchar(50),
`LEVEL` varchar(50),
`STANDARD` varchar(100),
`REMARK` text,
`UPID` varchar(100)
)
SELECT ID AS `ID`,
REPLACE(`-`,(length(ID)-3)*1)|NAME AS `ID_NAME`,
NAME AS `NAME`,
LEVEL AS `LEVEL` ,
STANDARD AS `STANDARD`,
REMARK AS `REMARK`,
UPID AS `UPID`
FROM `tblabel`