메타데이터를 통한 다중검색 쿼리 질문입니다.
ㄷㅊㅎ
6년 전
조회 6,353
메타데이터로 wr_1~wr_10까지 여분필드를 저장했습니다.
만약 리스트에서 여분필드값을 기준으로 검색을 한다고 할 때
하나의 여분필드로 검색을 진행하는 경우엔 아래 쿼리와 같이 사용했는데
만약 여러개의 여분필드의 값을 조건으로 하는 다중검색은 어떤식으로 쿼리를 작성해야 할까요?
</p>
<p><a href="<a href="http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Fselect.html&token=298777891ffb8ac930bdcdd8a74c2313" target="_blank" rel="noopener noreferrer">http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Fselect.html&token=298777891ffb8ac930bdcdd8a74c2313</a>" target="mysql_doc">SELECT</a> SQL_CALC_FOUND_ROWS *
FROM wp_g5_write a
<a href="<a href="http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Fstring-functions.html%23function_left&token=298777891ffb8ac930bdcdd8a74c2313" target="_blank" rel="noopener noreferrer">http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Fstring-functions.html%23function_left&token=298777891ffb8ac930bdcdd8a74c2313</a>" target="mysql_doc">LEFT</a> JOIN wp_g5_writemeta b ON a.wr_id <a href="<a href="http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Fcomparison-operators.html%23operator_equal&token=298777891ffb8ac930bdcdd8a74c2313" target="_blank" rel="noopener noreferrer">http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Fcomparison-operators.html%23operator_equal&token=298777891ffb8ac930bdcdd8a74c2313</a>" target="mysql_doc">=</a> b.g5_wr_id
WHERE ca_name <a href="<a href="http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Fcomparison-operators.html%23operator_equal&token=298777891ffb8ac930bdcdd8a74c2313" target="_blank" rel="noopener noreferrer">http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Fcomparison-operators.html%23operator_equal&token=298777891ffb8ac930bdcdd8a74c2313</a>" target="mysql_doc">=</a> '분류1'
<a href="<a href="http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Flogical-operators.html%23operator_and&token=298777891ffb8ac930bdcdd8a74c2313" target="_blank" rel="noopener noreferrer">http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Flogical-operators.html%23operator_and&token=298777891ffb8ac930bdcdd8a74c2313</a>" target="mysql_doc">AND</a> (</p>
<p>(</p>
<p><a href="<a href="http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Fstring-functions.html%23function_instr&token=298777891ffb8ac930bdcdd8a74c2313" target="_blank" rel="noopener noreferrer">http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Fstring-functions.html%23function_instr&token=298777891ffb8ac930bdcdd8a74c2313</a>" target="mysql_doc">INSTR</a>( wr_subject, '제목' )</p>
<p>)</p>
<p>)
<a href="<a href="http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Flogical-operators.html%23operator_and&token=298777891ffb8ac930bdcdd8a74c2313" target="_blank" rel="noopener noreferrer">http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Flogical-operators.html%23operator_and&token=298777891ffb8ac930bdcdd8a74c2313</a>" target="mysql_doc">AND</a> bo_table <a href="<a href="http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Fcomparison-operators.html%23operator_equal&token=298777891ffb8ac930bdcdd8a74c2313" target="_blank" rel="noopener noreferrer">http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Fcomparison-operators.html%23operator_equal&token=298777891ffb8ac930bdcdd8a74c2313</a>" target="mysql_doc">=</a> 'bbs'
<a href="<a href="http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Flogical-operators.html%23operator_and&token=298777891ffb8ac930bdcdd8a74c2313" target="_blank" rel="noopener noreferrer">http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Flogical-operators.html%23operator_and&token=298777891ffb8ac930bdcdd8a74c2313</a>" target="mysql_doc">AND</a> (</p>
<p>wr_num
BETWEEN <a href="<a href="http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Farithmetic-functions.html%23operator_minus&token=298777891ffb8ac930bdcdd8a74c2313" target="_blank" rel="noopener noreferrer">http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Farithmetic-functions.html%23operator_minus&token=298777891ffb8ac930bdcdd8a74c2313</a>" target="mysql_doc">-</a>1
<a href="<a href="http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Flogical-operators.html%23operator_and&token=298777891ffb8ac930bdcdd8a74c2313" target="_blank" rel="noopener noreferrer">http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Flogical-operators.html%23operator_and&token=298777891ffb8ac930bdcdd8a74c2313</a>" target="mysql_doc">AND</a> (</p>
<p><a href="<a href="http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Farithmetic-functions.html%23operator_minus&token=298777891ffb8ac930bdcdd8a74c2313" target="_blank" rel="noopener noreferrer">http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Farithmetic-functions.html%23operator_minus&token=298777891ffb8ac930bdcdd8a74c2313</a>" target="mysql_doc">-</a>1 <a href="<a href="http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Farithmetic-functions.html%23operator_plus&token=298777891ffb8ac930bdcdd8a74c2313" target="_blank" rel="noopener noreferrer">http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Farithmetic-functions.html%23operator_plus&token=298777891ffb8ac930bdcdd8a74c2313</a>" target="mysql_doc">+</a>10000</p>
<p>)</p>
<p>)
<a href="<a href="http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Flogical-operators.html%23operator_and&token=298777891ffb8ac930bdcdd8a74c2313" target="_blank" rel="noopener noreferrer">http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Flogical-operators.html%23operator_and&token=298777891ffb8ac930bdcdd8a74c2313</a>" target="mysql_doc">AND</a> (</p>
<p>b.meta_key <a href="<a href="http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Fcomparison-operators.html%23operator_equal&token=298777891ffb8ac930bdcdd8a74c2313" target="_blank" rel="noopener noreferrer">http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Fcomparison-operators.html%23operator_equal&token=298777891ffb8ac930bdcdd8a74c2313</a>" target="mysql_doc">=</a> 'wr_1'
<a href="<a href="http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Flogical-operators.html%23operator_and&token=298777891ffb8ac930bdcdd8a74c2313" target="_blank" rel="noopener noreferrer">http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Flogical-operators.html%23operator_and&token=298777891ffb8ac930bdcdd8a74c2313</a>" target="mysql_doc">AND</a> b.meta_value <a href="<a href="http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Fcomparison-operators.html%23operator_equal&token=298777891ffb8ac930bdcdd8a74c2313" target="_blank" rel="noopener noreferrer">http://placecompany.kr/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Fcomparison-operators.html%23operator_equal&token=298777891ffb8ac930bdcdd8a74c2313</a>" target="mysql_doc">=</a> '2019년'</p>
<p>)
ORDER BY wr_num, wr_parent
LIMIT 0 , 15</p>
<p>
댓글을 작성하려면 로그인이 필요합니다.
답변 1개
답변을 작성하려면 로그인이 필요합니다.
로그인