mysql字串替換,mysql字串

來源:互聯網
上載者:User

mysql字串替換,mysql字串
   我現在有這樣一個需求:在資料中有一個欄位的資料形如“0-300”現在需要將資料替換成“0~300”。                    
解決的sql如下:UPDATE tj_item_result SET reference_range=REPLACE(reference_range,'—','~') WHERE reference_range LIKE '%—%'

執行完之後,所有資料都變成了我想要的資料了。


mysql字串替換

update lesson set slide_path_dx = replace(slide_path_dx,"www.site.com/","E:\\web\\manhua\\")
update lesson set slide_path_dx = replace(slide_path_dx,"/","\\")
做之前記得備份資料,以防止出現考慮不周的情況.
 
MYSQL怎替換字串

你資料的具體情況我不是很清楚,這兩種語句你自己看著用吧
select stuff(subject,1,7,'') as subject from pb_tudouthreads
--stuff(列名,從第幾個字元開始,長度,替換成什麼)

UPDATE pb_tudouthreads
SET subject= REPLACE(subject, LEFT(subject, 7), '')
WHERE (subject NOT LIKE '生活小常識——”%')
 

相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.