[MYSQL] MYSQL之函数篇

概述：MYSQL 函数篇

案例实践

案例: replace(column, sourcrStr, targetStr)

select 
  replace('VA2.14', 'VA', '') as r1 -- '2.14'

案例: 字符串转浮点数

select 
  replace('V1.25', 'V', '') as r1 -- '1.25'
  , CAST( replace('V1.25', 'V', '') AS DECIMAL(10, 2)) as r2 -- 1.25

Y 推荐文献

X 参考文献

posted @ 2025-04-07 20:53  千千寰宇  阅读(14)  评论(0)    收藏  举报