-- iuap_yonbuilder_service库 -- 查询包含'AppContext'关键字的函数文件 SELECT e.description, e.source_flag, e.file_name, c.file_content, LOCATE( 'AppContext', c.file_content ) FROM hpa_extcode_content c LEFT JOIN hpa_extcode e ON c.fk_ext_code = e.id WHERE LOCATE( 'AppContext', c.file_content ) AND c.dr = 0 AND e.dr = 0 -- 查询包含' cb.rest '关键字的函数文件 SELECT e.description, e.source_flag, e.file_name, c.file_content, LOCATE( ' cb.rest', c.file_content ) FROM hpa_extcode_content c LEFT JOIN hpa_extcode e ON c.fk_ext_code = e.id WHERE LOCATE( ' cb.rest', c.file_content ) AND c.dr = 0 AND e.dr = 0
标签:LOCATE,V3.0,R2,extcode,2302,content,file,hpa,dr From: https://www.cnblogs.com/LFxanla/p/17265663.html