스크립트/Php 코드 팁

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

Font_Charisma 2009. 5. 24. 18:03


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);