mysql替换字段内容

update movie2 set brief =replace(brief,'<span class="closeinfo_tigger"><a href="javascript://" onclick="MovieInfoCtrl.showLess(0);">收起详细介绍</a></span>','' ) ;

update movie2 set brief =replace(brief,'<a.*a>','' ) ;

select * from movie2 where brief like '<a.*a>';

update movie2 set brief =substring(brief,1, locate('<a', brief)-1 ) where brief like '%<%';
update movie2 set brief =substring(brief,1, 4 ) where mid='15588';