컴

mysql like 검색방법

· 2012-12-02 (일) 12:52:59 · 7521 · 9
너무 궁금해서 아무리 찾아도 저와 비슷한 질문을 한 사람이 없더군요. like 검색시에 대소문자를 구분해서 검색하는 방법이 뭐가 있을까 생각하다가... 예를들어, name 컬럼에 abc 라는 값이 들어있고, select * from table where name like '%Bc%' 이렇게 해도 검색이 되더라 이겁니다. 물론 필드형을 바꾸어 주거나 하는 방법이 있지만.... select * from table where binary(name) like '%Bc%' 이렇게 하면 대소문자를 구분하여 검색이 안되고, select * from table where binary(name) like '%bc%' 이렇게 해야만 검색

첨부파일

mysql_like_검색.txt (50 bytes) 48회 2012-12-02 13:10

댓글 9개

http://dev.mysql.com/doc/refman/5.5/en/case-sensitivity.html

To make this search case sensitive, make sure that one of the operands has a case sensitive or binary collation. For example, if you are comparing a column and a string that both have the latin1 character set, you can use the COLLATE operator to cause either operand to have the latin1_general_cs or latin1_bin collation:

col_name COLLATE latin1_general_cs LIKE 'a%'
col_name LIKE 'a%' COLLATE latin1_general_cs
col_name COLLATE latin1_bin LIKE 'a%'
col_name LIKE 'a%' COLLATE latin1_bin
감사합니다
댓글을 작성하시려면 로그인이 필요합니다.

프로그램

8,187건
+
제목 글쓴이 날짜 조회
12-11-22 조회 4,815
12-11-22 조회 6,342
12-11-22 조회 6,358
12-11-22 조회 5,342
12-11-22 조회 8,574
12-11-21 조회 6,097
12-11-21 조회 8,673
12-11-20 조회 4,938
12-11-20 조회 2.4만
12-11-19 조회 4,090
12-11-19 조회 4,576
12-11-19 조회 2만
12-11-18 조회 5,491
12-11-16 조회 4,127
12-11-16 조회 6,511
12-11-16 조회 4,255
12-11-16 조회 4,510
12-11-15 조회 3,868
12-11-15 조회 5,652
12-11-15 조회 4,531
12-11-15 조회 3,813
12-11-14 조회 3,598
12-11-14 조회 1만
12-11-14 조회 5,074
12-11-13 조회 4,096
12-11-13 조회 3,877
12-11-12 조회 5,713
12-11-12 조회 4,084
12-11-11 조회 2.2만
12-11-09 조회 5,664
12-11-09 조회 5,850
12-11-09 조회 7,728
12-11-08 조회 4,942
12-11-06 조회 3,881
12-11-06 조회 4,044
12-11-06 조회 1.9만
12-11-05 조회 4,017
12-11-05 조회 4,907
12-11-05 조회 4,423
12-11-05 조회 4,146
12-11-04 조회 4,118
12-11-03 조회 4,225
12-11-03 조회 2.6만
12-11-02 조회 5,234
12-11-02 조회 3.2만
12-11-01 조회 5,225
12-11-01 조회 2.6만
12-10-30 조회 8,423
12-10-30 조회 3,944
12-10-29 조회 3,973
12-10-29 조회 5,239
12-10-29 조회 4,082
12-10-29 조회 4,915
12-10-28 조회 4,134
12-10-26 조회 3,901
12-10-26 조회 9,926
12-10-26 조회 8,204
12-10-25 조회 4,055
12-10-25 조회 4,139
12-10-25 조회 8,253
12-10-24 조회 9,723
12-10-23 조회 4,166
12-10-23 조회 3,426
12-10-23 조회 3,736
12-10-23 조회 4,983
12-10-22 조회 8,566
12-10-21 조회 4,083
12-10-20 조회 4,722
12-10-19 조회 4,538
12-10-19 조회 3,527
12-10-18 조회 4,166
12-10-18 조회 3,783
12-10-18 조회 3,621
12-10-17 조회 9,448
12-10-17 조회 3,744
12-10-16 조회 3,592
12-10-16 조회 5,662
12-10-16 조회 4,090
12-10-16 조회 6,450
12-10-16 조회 4,280
12-10-15 조회 4,013
12-10-15 조회 3,536
12-10-15 조회 3,512
12-10-14 조회 3,859
12-10-13 조회 3,875
12-10-12 조회 4,778
12-10-12 조회 4,100
12-10-11 조회 5,143
12-10-11 조회 4,145
12-10-10 조회 7,153
12-10-10 조회 6,472
12-10-10 조회 8,077
12-10-10 조회 1.1만
12-10-10 조회 5,732
12-10-10 조회 5,273
12-10-10 조회 3,608
12-10-09 조회 6,073
12-10-09 조회 3,810
12-10-09 조회 7,378
12-10-09 조회 5,541