본문 바로가기

스크립트/Php 코드 팁

mysql 999999만 빼고 숫자로 나열하기



select * from g4_member where mb_id not like '%999999%' order by mb_id asc



참고로 이렇게 쓸수있습니다.


$gmember = "select * from g4_member where mb_id not like '%999999%' order by mb_id asc" ; 
$gmember2 = mysql_query($gmember, $connect);
$gmemberm = mysql_fetch_array($gmember2);