城杆

set names latin1

SELECT * from cuku_card


select * from cuku_card where cardname like '%武夷山%'  and catname = '三明旅游'


update cuku_card set catname  = '名胜之旅' where  cardname like '%漳州%'


update cuku_card set catname  = '武夷山'  where cardname like '%武夷山%'  and catname = '三明旅游'

select * from cuku_card where catname  = '天然奇观之旅'

delete from cuku_card where catname  = ''




select * from cuku_card where price_not = ""

select * from wurc163_lvyou.cuku_card where price_not = ""


select  b.price_not from cuku_card a,wurc163_lvyou.cuku_card b  where a.id = b.id

UPDATE cuku_card,cuku_card_copy set cuku_card.price_have=cuku_card_copy.price_have where cuku_card.id=cuku_card_copy.id and  cuku_card.price_have = ""




select id,price_mode from cuku_card where shichang>0

select price_have from cuku_card where shichang>0 and price_have like '%126元%'

select shichang, price_mode from cuku_card where  price_mode like '%元%'

UPDATE cuku_card set  price_have=replace(price_have,'13806042629','') where shichang>0 and price_have like '%13806042629%'