D

영카트에서 카테고리 검색하기

navigation2.inc.php에 보면 다음 조건이 있는데

$len=2;
$len2 = $len + 2;

select ... where SUBSTRING(ca_id,1,$len) = '$tmp_ca_id'
and LENGTH(ca_id) = '$len2'

이걸 다음 처럼 바꾸면 좀 더 효율적입니다.

select .... where ca_id like '{$ca_id}__' or ca_id like '{$ca_id}____'<div class='small'>[이 게시물은 관리자님에 의해 2011-10-31 17:27:00 MySQL에서 이동 됨]</div>
|
댓글을 작성하시려면 로그인이 필요합니다.

프로그램

8,188건
+
제목 글쓴이 날짜 조회
06-09-21 조회 3,804
06-09-21 조회 3,642
06-09-21 조회 2,963
06-09-21 조회 3,194
06-09-21 조회 4,407
06-09-21 조회 3,067
06-09-21 조회 3,560
06-09-21 조회 3,657
06-09-21 조회 3,792
06-09-21 조회 4,018
06-09-21 조회 3,712
06-09-21 조회 4,175
06-09-21 조회 3,948
06-09-21 조회 4,601
06-09-20 조회 2,988
06-09-19 조회 3,878
06-09-18 조회 3,521
06-09-15 조회 3,118
06-09-15 조회 3,519
06-09-15 조회 2,962
06-09-15 조회 6,575
06-09-15 조회 3,373
06-09-13 조회 5,321
06-09-13 조회 3,426
06-09-11 조회 2,975
06-09-11 조회 3,662
06-09-11 조회 3,408
06-09-11 조회 3,621
06-09-11 조회 3,240
06-09-11 조회 4,967
06-09-11 조회 4,473
06-09-11 조회 3,267
06-09-11 조회 3,214
06-09-10 조회 3,094
06-09-06 조회 3,093
06-09-05 조회 5,425
06-09-04 조회 4,432
06-09-04 조회 3,841
06-09-03 조회 4,408
06-09-02 조회 4,044
06-09-02 조회 3,896
06-09-02 조회 3,503
06-09-01 조회 3,248
06-09-01 조회 3,568
06-09-01 조회 4,124
06-08-31 조회 3,150
06-08-31 조회 4,207
06-08-28 조회 4,328
06-08-27 조회 3,975
06-08-27 조회 3,058
06-08-27 조회 2,755
06-08-27 조회 3,371
06-08-27 조회 3,351
06-08-27 조회 2,683
06-08-27 조회 2,708
06-08-27 조회 2,604
06-08-27 조회 3,099
06-08-27 조회 2,673
06-08-27 조회 3,226
06-08-27 조회 2,992
06-08-27 조회 2,874
06-08-27 조회 2,695
06-08-27 조회 2,892
06-08-27 조회 2,953
06-08-27 조회 2,988
06-08-27 조회 3,725
06-08-27 조회 6,368
06-08-27 조회 2,768
06-08-27 조회 2,624
06-08-27 조회 2,451
06-08-27 조회 2,661
06-08-27 조회 2,573
06-08-27 조회 2,514
06-08-27 조회 2,535
06-08-27 조회 2,433
06-08-27 조회 2,500
06-08-27 조회 3,970
06-08-27 조회 4,927
06-08-26 조회 6,295
06-08-26 조회 2,456
06-08-26 조회 5,612
06-08-25 조회 4,058
06-08-25 조회 2,594
06-08-24 조회 3,766
06-08-24 조회 4,688
06-08-24 조회 2,834
06-08-23 조회 4,871
06-08-23 조회 2,955
06-08-23 조회 4,819
06-08-23 조회 4,499
06-08-23 조회 5,237
06-08-23 조회 5,098
06-08-22 조회 2,894
06-08-22 조회 2,870
06-08-21 조회 5,334
06-08-20 조회 3,724
06-08-20 조회 3,617
06-08-19 조회 3,448
06-08-19 조회 3,015
06-08-18 조회 3,657