|
楼主 |
发表于 2014-6-11 20:25:34
|
显示全部楼层
本帖最后由 fbms 于 2014-6-11 20:30 编辑
- k4 \' }3 h1 ^7 D- n- @; R& p% }1 s O
我发现,还不错。就用0.05版medit 没有另外写程序,但是需要写sql语句。- --select * from Tma where definition like '%href="sound%'
4 h1 Z/ y7 m3 m - * `) _% Y8 r H
- ) m2 c1 b( y; {6 M' x4 H4 ^, Q) {
; r, Y# K8 F; d2 u C, w0 \+ j7 T: T- select word , substr(definition , instr(definition ,'href="sound' )-3 ,) t/ ~% ~* |: ?
- instr(definition, '"speaker.png" style="margin-bottom:-2px" />' ) - instr(definition ,'href="sound' )+50 ) definition
1 W- x* e* c+ d& w - from Tma where definition like '%href="sound%'
t; k) _$ d ]4 N - . b8 f8 d2 B! k
-
/ ]7 E; C9 A& `+ n; }: ` -
9 H7 |) D; i% B! B1 E1 J4 H
" G# B0 p- O# ~+ x8 g* o) g
( J$ Y. \5 k! Y) \- --update Tma set definition = replace( definition, 'sound://spx/', 'sound://spx' ) WHERE definition like '%href="sound%'
' u) V8 E. p! p: K - 6 ]% U& g' T( |9 v
- --update Tma set definition = replace( definition, '/speaker.png', 'speaker.png' ) WHERE definition like '%speaker.png%'
3 I6 m1 G5 d0 {: O0 m7 w. Z
! e5 L1 a7 q" N0 ?- w0 |0 b, M" l- 6 r# S5 @. @7 @7 S
- <a href="sound://spx00015.spx"><img border="0" height="20" width="20" src="speaker.png" style="margin-bottom:-2px" /></a>
. t1 i7 s) G' j: n( A
3 Y) O: `! D, {! L- select a.word , substr (a.definition ,0 ,instr ( a.definition ,'snd_us.png" style="margin-bottom:-4px" border="0" ></img></a>' ) +61 ) || ' ' || b.definition || ' '|| substr (a.definition ,instr ( a.definition ,'snd_us.png" style="margin-bottom:-4px" border="0" ></img></a>' ) +62, 100000 )
9 J0 V) {4 p5 a4 U' ^4 O - definition from XXXX3 a join mma b on a.word =b.word
复制代码 |
本帖子中包含更多资源
您需要 登录 才可以下载或查看,没有账号?免费注册
x
|