PHP截取字符串小括号的内容

 

{:substr($vo.lot,0,strpos($vo.lot, '('))}

mysql中字符串去掉括号以及括号的内容

substring_index(substring_index(a.lot,'(',1),')',-1) as lots