mysql regexp正则用例及数据导出方式

www.xun800.com  

迅800

找正装

++++++++++++++++++++++++++++++

#规则：
1.关键词：专柜正品 专柜正装 有盒有塑封 有外盒无塑封 内附说明 正装

*专柜|正装|正品|有盒|塑封|有外盒|内附说明|正装.*"\G;
select distinct(product_id),short_name from tuanmei_deals where note regexp ".*专柜|正装|正品|有盒|塑封|有外盒|内附说明|正装.*"\G;


导出
******************************


mysqldump  -uroot -p111111 --default-character-set=latin1 db_pdc task_skupmc | gzip > db_pdc_skupmc_1217.sql
mysqldump  -uroot -p111111 db_pdc task_skupmc | gzip > db_pdc_skupmc_1217.sql


#导出结果集的sql
SELECT product_id,short_name,brand_id,brand, 
case res_tuanmei_deals when 0 then '未知' when 1 then '疑似小样' when 2 then '小样' when 3 then '疑似正装' when 4 then '正装' end as 'res_tuanmei_deals', 
case res_tuanmei_products when 0 then '未知' when 1 then '疑似小样' when 2 then '小样' when 3 then '疑似正装' when 4 then '正装' end as 'res_tuanmei_products', 
case res_koubei when 0 then '未知' when 1 then '疑似小样' when 2 then '小样' when 3 then '疑似正装' when 4 then '正装' end as 'res_koubei', 
res_hand FROM `task_skupmc` where sku_no='' order by 'res_koubei' desc,'res_tuanmei_deals' desc,'res_tuanmei_products' desc;


#导出命令
mysql -uroot -p111111 --default-character-set=latin1 db_pdc < my.sql > product_type_check_1217.xls