String Extractor
Regular Expression 또는 delimiter를 이용하여 소스에서 원하는 부분을 추출하고
추출된 문자열을 을 통해서 가공하는 기능을 제공한다.
Use Regular Expression
Use Delimiter
Use User Function
Function
ADD()
ARG()
DAT()
DEC()
DIV()
LEN()
LOW()
MAX()
MUL()
SEQ()
STR()
SUBSTR()
SUB()
UPP()
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001945s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.084817s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002439s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002204s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002204s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003780s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002112s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003298s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014533s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002297s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 262416 [ RunTime:0.001172s ]