정보 통신 기술 용어 해설 ( 개선 중 ) 
 소스 파 일 명 : srch _ utils . php 
 <? php / / ( 2017 . 12 . 30 , 차 재복 , Cha Jae Bok , cjbword @ gmailcom ) 
 # 한글 ( 1 ) , 영어 ( 0 ) 구분 
 # 검색어 길 이 
 # [ super ] 현재 검색어 는 ? 
 # 검색어 요소 별 정돈 
 # 한글 의미 어 분리 
 SELECT a . word , a . wordtype , b . yako , b . full _ name , b . korean , b . extra _ keyword , b . synopsis , a . no , b . abbr 
 + SUM ( IF ( CONCAT ( ' ','$ m _ search ',' ') LIKE CONCAT ( '% ', a . word , ' %'), 30 , 0 ) ) 
 + SUM ( IF ( CONCAT ( ' ', a . word , ' ') LIKE CONCAT ( '% ','$ m _ search ',' %'), 30 , 0 ) ) 
 + SUM ( IF ( REPLACE ( a . word , '-',' ') LIKE CONCAT ( '%','$ m _ search ','%'), 6 , 0 ) ) 
 # 	 	 	 	 	 	 , ( SUBSTRING _ INDEX ( SUBSTRING _ INDEX ( a . word , ' ', 2 ) , ' ',- 1 ) ) AS temp _ word 
 || CONCAT ( ' ','$ m _ search ',' ') LIKE CONCAT ( '% ', a . word , ' s %') 
 # ( search 에서 word 를 검색 ) 
 || IF ( CHAR _ LENGTH ( a . word ) > 2 , CONCAT ( ' ','$ m _ search ',' ') LIKE CONCAT ( '%', a . word , '%'), 0 ) 
 || REPLACE ( a . word , '-',' ') LIKE CONCAT ( '%','$ m _ search ','%') 
 || ( CASE ( LENGTH ( REPLACE ( a . word , '-',' '))- LENGTH ( REPLACE ( REPLACE ( a . word , '-',' '),' ','')))/ LENGTH ( ' ') 
 WHEN 1 THEN ( '$ m _ search ' LIKE CONCAT ( '%', SUBSTRING _ INDEX ( REPLACE ( a . word , '-',' '),' ', 1 ) , '%')) AND ( '$ m _ search ' LIKE CONCAT ( '%', SUBSTRING _ INDEX ( SUBSTRING _ INDEX ( REPLACE ( a . word , '-',' '),' ', 2 ) , ' ',- 1 ) , '%')) 
 WHEN 2 THEN ( '$ m _ search ' LIKE CONCAT ( '%', SUBSTRING _ INDEX ( REPLACE ( a . word , '-',' '),' ', 1 ) , '%')) AND ( '$ m _ search ' LIKE CONCAT ( '%', SUBSTRING _ INDEX ( SUBSTRING _ INDEX ( REPLACE ( a . word , '-',' '),' ', 2 ) , ' ',- 1 ) , '%')) AND ( '$ m _ search ' LIKE CONCAT ( '%', SUBSTRING _ INDEX ( REPLACE ( a . word , '-',' '),' ',- 1 ) , '%')) 
 || ( CASE ( LENGTH ( REPLACE ( '$ m _ search ','-',' '))- LENGTH ( REPLACE ( REPLACE ( '$ m _ search ','-',' '),' ','')))/ LENGTH ( ' ') 
 WHEN 1 THEN ( a . word LIKE CONCAT ( '%', SUBSTRING _ INDEX ( REPLACE ( '$ m _ search ','-',' '),' ', 1 ) , '%')) AND ( a . word LIKE CONCAT ( '%', SUBSTRING _ INDEX ( REPLACE ( '$ m _ search ','-',' '),' ',- 1 ) , '%')) 
 WHEN 2 THEN ( a . word LIKE CONCAT ( '%', SUBSTRING _ INDEX ( REPLACE ( '$ m _ search ','-',' '),' ', 1 ) , '%')) AND ( a . word LIKE CONCAT ( '%', SUBSTRING _ INDEX ( SUBSTRING _ INDEX ( REPLACE ( '$ m _ search ','-',' '),' ', 2 ) , ' ',- 1 ) , '%')) AND ( a . word LIKE CONCAT ( '%', SUBSTRING _ INDEX ( REPLACE ( '$ m _ search ','-',' '),' ',- 1 ) , '%')) 
 # 3 자 이상 약어 word 
 # 1 단어 ( 빈 칸 없 음 ) , 길 이 차이 3 자 미만 
 GROUP BY a . no 
 || CASE ( LENGTH ( a . word ) - LENGTH ( REPLACE ( a . word , ' ','')))/ LENGTH ( ' ') 
 WHEN 1 THEN ( SUBSTRING _ INDEX ( word , ' ', 1 ) AND SUBSTRING _ INDEX ( SUBSTRING _ INDEX ( word , ' ', 2 ) , ' ',- 1 ) ) 
 REPLACE ( REPLACE ( a . word , '-',' '),'/',' ')