substring_index(str,delim,count) 說明:substring_index(被截取字段,關(guān)鍵字,關(guān)鍵字出現(xiàn)的次數(shù)) 例:select substring_index("blog.jb51.net","。",2) as abstract from my_content_t 結(jié)果:blog.jb51 (注:如果關(guān)鍵字出現(xiàn)的次數(shù)是負(fù)數(shù) 如-2 則是從后倒數(shù),到字符串結(jié)束) ...
www.dbjr.com.cn/article/274...htm 2025-6-6