instr 사용법 : like 보다 훨씬 속도 빠르다고 합니다!

 

 

//나비야넷 , 뉴마사지 코딩수정하면서 배운점 
// ■ ■  instr 사용법  :  like 보다 훨씬 속도 빠르다고 합니다!  
// 1번이 2번보다 더 빠름^^

 

$sql2="select  count(*) as cnt  from g5_write_TEST  where INSTR( wr_subject , '부산'  ) > 0   ";//■1번
//$sql2="select  count(*) as cnt  from g5_write_TEST where wr_subject like '%부산%'   ";//■2번
$result2 = sql_query($sql2);
$row2 = sql_fetch_array($result2);

echo $row2[cnt]."<br>---------<br>"; 


$i=1;
$sql="select  *  from g5_write_TEST where INSTR( wr_subject , '부산'  ) > 0   "; //■1번
//$sql="select *  from g5_write_TEST where wr_subject like '%부산%'   "; //■2번
$result = sql_query($sql);
while($row = sql_fetch_array($result)){
  $a.="$i ) $row[wr_subject]<br>"; 
  $i++;
}
echo $a;

 

 

// 출처 : https://www.phpschool.com/gnuboard4/bbs/board.php?bo_table=tipntech&wr_id=16801

// └ 넘감사합니다! 번창하세요!!!