fulltext 검색에서 match against에 대해서 채택완료
db는 innodb이고 wr_subject필드를 fulltext로 인덱싱하고
https://fla.jamakav.com:2087/cpsess2752431004/3rdparty/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/select.html" target="mysql_doc">select wr_id,wr_is_comment,ca_name,wr_subject,wr_content from g5_write_jamakuser where https://fla.jamakav.com:2087/cpsess2752431004/3rdparty/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html#function_match" target="mysql_doc">match(wr_subject) against('SSNI-655' https://fla.jamakav.com:2087/cpsess2752431004/3rdparty/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/comparison-operators.html#function_in" target="mysql_doc">in https://fla.jamakav.com:2087/cpsess2752431004/3rdparty/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/numeric-types.html" target="mysql_doc">boolean mode) order by wr_id desc limit 0, 10
이와같이 쿼리를 날리면 왜 결과가 이처럼 나올까요? SSNI-655가 있는것만 나오게 할려면 어떻게 해야 할까요?
답변 1개
답변을 작성하려면 로그인이 필요합니다.
로그인