mysql 字符串函數

 注意以下  sql 均在  putty 下運行,  所以對中文的支持不好

    (當輸入的中文字符集是 big5 , 而要求存儲的是  utf8, 而putty 只支持簡體中文 或者其他特殊情況時.......)

 

select menu_name_cn from menu_item where menu_id=23;
+----------------+
| menu_name_cn   |
+----------------+
| '100M¥úÅÖ¼eÀW' |
+----------------+
 

select SUBSTRING_INDEX(menu_name_cn, '/'',1) from menu_item where menu_id=23;
+---------------------------------------+
| SUBSTRING_INDEX(menu_name_cn, '/'',1) |
+---------------------------------------+
|                                       |
+---------------------------------------+
 

select SUBSTRING(menu_name_cn,2) from menu_item where menu_id=23;
+---------------------------+
| SUBSTRING(menu_name_cn,2) |
+---------------------------+
| 100M¥úÅÖ¼eÀW'             |
+---------------------------+
 

select SUBSTRING(menu_name_cn,3) from menu_item where menu_id=23;
+---------------------------+
| SUBSTRING(menu_name_cn,3) |
+---------------------------+
| 00M¥úÅÖ¼eÀW'              |
+---------------------------+
 

select SUBSTRING_INDEX(menu_name_cn, '/'',2) from menu_item where menu_id=23;
+---------------------------------------+
| SUBSTRING_INDEX(menu_name_cn, '/'',2) |
+---------------------------------------+
| '100M¥úÅÖ¼eÀW                         |
+---------------------------------------+

 

 

update menu_item set menu_name_cn= CONCAT("'150M",SUBSTRING(menu_name_cn,6)) where menu_id=24;

 

 

 

 

update menu_item set menu_name_cn = replace(menu_name_cn,"10","25") where menu_id=25;