안녕하세요 sql 관련해서 질문드립니다. <div><br></div> <div><div>SELECT id,purchase_num,purchase_date </div> <div>FROM purchase</div> <div>WHERE purchase_num</div> <div>REGEXP '^[0-9]{3}.+$' ORDER BY id DESC LIMIT 0,5</div></div> <div><br></div> <div><br></div> <div><div style="margin:0px;overflow:hidden;height:0px;"> <div style="margin:0px;"><div class="formelement" style="float:left;margin-right:.5em;"><br><br></div> <div class="formelement" style="float:left;margin-right:.5em;"><br><br></div> <div class="formelement" style="float:left;margin-right:.5em;"><br></div> <div class="formelement" style="float:left;margin-right:.5em;"></div> <div class="clearfloat" style="clear:both;"></div></div></div><table class="data"><thead><tr><th colspan="3" style="padding:.1em .5em;margin:.1em;vertical-align:top;background:#d3dce3;"></th> <th style="padding:.1em .5em;margin:.1em;vertical-align:top;background:#d3dce3;"><a target="_blank" href="http://bncfashion.co.nz/bnc/awolfenstein/sql.php?db=pos&table=purchase&sql_query=REGEXP+%27%5E%5B0-9%5D%7B3%7D.%2B%24%27+ORDER+BY+%60purchase%60.%60id%60++ASC+LIMIT+0+%2C+5&token=97616f6795c16ce1fd2396463e18d5cc" title="정렬" style="text-decoration:none;color:#0000ff;" target="_blank">id <img class="icon" src="http://bncfashion.co.nz/bnc/awolfenstein/themes/original/img/s_desc.png" width="11" height="9" alt="내림차순(역순)" title="내림차순(역순)" style="vertical-align:middle;border:0px;margin-right:.3em;margin-left:.3em;"></a></th> <th class="condition" style="padding:.1em .5em;margin:.1em;vertical-align:top;border:1px solid rgb(255,204,153);background:#d3dce3;"><a target="_blank" href="http://bncfashion.co.nz/bnc/awolfenstein/sql.php?db=pos&table=purchase&sql_query=REGEXP+%27%5E%5B0-9%5D%7B3%7D.%2B%24%27+ORDER+BY+%60purchase%60.%60purchase_num%60+ASC+LIMIT+0+%2C+5&token=97616f6795c16ce1fd2396463e18d5cc" title="정렬" style="text-decoration:none;color:#0000ff;" target="_blank">purchase_num</a></th> <th style="padding:.1em .5em;margin:.1em;vertical-align:top;background:#d3dce3;"><a target="_blank" href="http://bncfashion.co.nz/bnc/awolfenstein/sql.php?db=pos&table=purchase&sql_query=REGEXP+%27%5E%5B0-9%5D%7B3%7D.%2B%24%27+ORDER+BY+%60purchase%60.%60purchase_date%60+ASC+LIMIT+0+%2C+5&token=97616f6795c16ce1fd2396463e18d5cc" title="정렬" style="text-decoration:none;color:#0000ff;" target="_blank">purchase_date</a></th></tr></thead><tbody><tr class="odd" style="background:#e5e5e5;"><td align="center" style="padding:.1em .5em;margin:.1em;vertical-align:top;"></td> <td align="center" style="padding:.1em .5em;margin:.1em;vertical-align:top;"><a target="_blank" href="http://bncfashion.co.nz/bnc/awolfenstein/tbl_change.php?db=pos&table=purchase&primary_key=%60purchase%60.%60id%60+%3D+852&clause_is_unique=1&sql_query=SELECT+id%2Cpurchase_num%2Cpurchase_date+%0D%0AFROM+purchase%0D%0AWHERE+purchase_num%0D%0AREGEXP+%27%5E%5B0-9%5D%7B3%7D.%2B%24%27+ORDER+BY+id+DESC+LIMIT+0%2C5&goto=sql.php&token=97616f6795c16ce1fd2396463e18d5cc" style="text-decoration:none;color:#0000ff;" target="_blank"><img src="http://bncfashion.co.nz/bnc/awolfenstein/themes/original/img/b_edit.png" title="수정" alt="수정" class="icon" width="16" height="16" style="vertical-align:middle;border:0px;margin:0px;"></a></td> <td align="center" style="padding:.1em .5em;margin:.1em;vertical-align:top;"><a target="_blank" href="http://bncfashion.co.nz/bnc/awolfenstein/sql.php?db=pos&table=purchase&sql_query=DELETE+FROM+%60pos%60.%60purchase%60+WHERE+%60purchase%60.%60id%60+%3D+852&zero_rows=%EC%84%A0%ED%83%9D%ED%95%9C+%EC%A4%84%28%EB%A0%88%EC%BD%94%EB%93%9C%29%EC%9D%84+%EC%82%AD%EC%A0%9C+%ED%95%98%EC%98%80%EC%8A%B5%EB%8B%88%EB%8B%A4.&goto=sql.php%3Fdb%3Dpos%26table%3Dpurchase%26sql_query%3DSELECT%2Bid%252Cpurchase_num%252Cpurchase_date%2B%250D%250AFROM%2Bpurchase%250D%250AWHERE%2Bpurchase_num%250D%250AREGEXP%2B%2527%255E%255B0-9%255D%257B3%257D.%252B%2524%2527%2BORDER%2BBY%2Bid%2BDESC%2BLIMIT%2B0%252C5%26zero_rows%3D%25EC%2584%25A0%25ED%2583%259D%25ED%2595%259C%2B%25EC%25A4%2584%2528%25EB%25A0%2588%25EC%25BD%2594%25EB%2593%259C%2529%25EC%259D%2584%2B%25EC%2582%25AD%25EC%25A0%259C%2B%25ED%2595%2598%25EC%2598%2580%25EC%258A%25B5%25EB%258B%2588%25EB%258B%25A4.%26goto%3Dtbl_sql.php%26token%3D97616f6795c16ce1fd2396463e18d5cc&token=97616f6795c16ce1fd2396463e18d5cc" style="text-decoration:none;color:#0000ff;" target="_blank"><img src="http://bncfashion.co.nz/bnc/awolfenstein/themes/original/img/b_drop.png" title="삭제" alt="삭제" class="icon" width="16" height="16" style="vertical-align:middle;border:0px;margin:0px;"></a></td> <td align="right" class="nowrap" style="padding:.1em .5em;margin:.1em;vertical-align:top;">852</td> <td class="condition" style="padding:.1em .5em;margin:.1em;vertical-align:top;border:1px solid rgb(255,204,153);">1511_1</td> <td class="nowrap" style="padding:.1em .5em;margin:.1em;vertical-align:top;">2015-07-29</td></tr><tr class="even" style="background:#d5d5d5;"><td align="center" style="padding:.1em .5em;margin:.1em;vertical-align:top;"></td> <td align="center" style="padding:.1em .5em;margin:.1em;vertical-align:top;"><a target="_blank" href="http://bncfashion.co.nz/bnc/awolfenstein/tbl_change.php?db=pos&table=purchase&primary_key=%60purchase%60.%60id%60+%3D+847&clause_is_unique=1&sql_query=SELECT+id%2Cpurchase_num%2Cpurchase_date+%0D%0AFROM+purchase%0D%0AWHERE+purchase_num%0D%0AREGEXP+%27%5E%5B0-9%5D%7B3%7D.%2B%24%27+ORDER+BY+id+DESC+LIMIT+0%2C5&goto=sql.php&token=97616f6795c16ce1fd2396463e18d5cc" style="text-decoration:none;color:#0000ff;" target="_blank"><img src="http://bncfashion.co.nz/bnc/awolfenstein/themes/original/img/b_edit.png" title="수정" alt="수정" class="icon" width="16" height="16" style="vertical-align:middle;border:0px;margin:0px;"></a></td> <td align="center" style="padding:.1em .5em;margin:.1em;vertical-align:top;"><a target="_blank" href="http://bncfashion.co.nz/bnc/awolfenstein/sql.php?db=pos&table=purchase&sql_query=DELETE+FROM+%60pos%60.%60purchase%60+WHERE+%60purchase%60.%60id%60+%3D+847&zero_rows=%EC%84%A0%ED%83%9D%ED%95%9C+%EC%A4%84%28%EB%A0%88%EC%BD%94%EB%93%9C%29%EC%9D%84+%EC%82%AD%EC%A0%9C+%ED%95%98%EC%98%80%EC%8A%B5%EB%8B%88%EB%8B%A4.&goto=sql.php%3Fdb%3Dpos%26table%3Dpurchase%26sql_query%3DSELECT%2Bid%252Cpurchase_num%252Cpurchase_date%2B%250D%250AFROM%2Bpurchase%250D%250AWHERE%2Bpurchase_num%250D%250AREGEXP%2B%2527%255E%255B0-9%255D%257B3%257D.%252B%2524%2527%2BORDER%2BBY%2Bid%2BDESC%2BLIMIT%2B0%252C5%26zero_rows%3D%25EC%2584%25A0%25ED%2583%259D%25ED%2595%259C%2B%25EC%25A4%2584%2528%25EB%25A0%2588%25EC%25BD%2594%25EB%2593%259C%2529%25EC%259D%2584%2B%25EC%2582%25AD%25EC%25A0%259C%2B%25ED%2595%2598%25EC%2598%2580%25EC%258A%25B5%25EB%258B%2588%25EB%258B%25A4.%26goto%3Dtbl_sql.php%26token%3D97616f6795c16ce1fd2396463e18d5cc&token=97616f6795c16ce1fd2396463e18d5cc" style="text-decoration:none;color:#0000ff;" target="_blank"><img src="http://bncfashion.co.nz/bnc/awolfenstein/themes/original/img/b_drop.png" title="삭제" alt="삭제" class="icon" width="16" height="16" style="vertical-align:middle;border:0px;margin:0px;"></a></td> <td align="right" class="nowrap" style="padding:.1em .5em;margin:.1em;vertical-align:top;">847</td> <td class="condition" style="padding:.1em .5em;margin:.1em;vertical-align:top;border:1px solid rgb(255,204,153);">1510_2</td> <td class="nowrap" style="padding:.1em .5em;margin:.1em;vertical-align:top;">2015-07-14</td></tr><tr class="odd" style="background:#e5e5e5;"><td align="center" style="padding:.1em .5em;margin:.1em;vertical-align:top;"></td> <td align="center" style="padding:.1em .5em;margin:.1em;vertical-align:top;"><a target="_blank" href="http://bncfashion.co.nz/bnc/awolfenstein/tbl_change.php?db=pos&table=purchase&primary_key=%60purchase%60.%60id%60+%3D+841&clause_is_unique=1&sql_query=SELECT+id%2Cpurchase_num%2Cpurchase_date+%0D%0AFROM+purchase%0D%0AWHERE+purchase_num%0D%0AREGEXP+%27%5E%5B0-9%5D%7B3%7D.%2B%24%27+ORDER+BY+id+DESC+LIMIT+0%2C5&goto=sql.php&token=97616f6795c16ce1fd2396463e18d5cc" style="text-decoration:none;color:#0000ff;" target="_blank"><img src="http://bncfashion.co.nz/bnc/awolfenstein/themes/original/img/b_edit.png" title="수정" alt="수정" class="icon" width="16" height="16" style="vertical-align:middle;border:0px;margin:0px;"></a></td> <td align="center" style="padding:.1em .5em;margin:.1em;vertical-align:top;"><a target="_blank" href="http://bncfashion.co.nz/bnc/awolfenstein/sql.php?db=pos&table=purchase&sql_query=DELETE+FROM+%60pos%60.%60purchase%60+WHERE+%60purchase%60.%60id%60+%3D+841&zero_rows=%EC%84%A0%ED%83%9D%ED%95%9C+%EC%A4%84%28%EB%A0%88%EC%BD%94%EB%93%9C%29%EC%9D%84+%EC%82%AD%EC%A0%9C+%ED%95%98%EC%98%80%EC%8A%B5%EB%8B%88%EB%8B%A4.&goto=sql.php%3Fdb%3Dpos%26table%3Dpurchase%26sql_query%3DSELECT%2Bid%252Cpurchase_num%252Cpurchase_date%2B%250D%250AFROM%2Bpurchase%250D%250AWHERE%2Bpurchase_num%250D%250AREGEXP%2B%2527%255E%255B0-9%255D%257B3%257D.%252B%2524%2527%2BORDER%2BBY%2Bid%2BDESC%2BLIMIT%2B0%252C5%26zero_rows%3D%25EC%2584%25A0%25ED%2583%259D%25ED%2595%259C%2B%25EC%25A4%2584%2528%25EB%25A0%2588%25EC%25BD%2594%25EB%2593%259C%2529%25EC%259D%2584%2B%25EC%2582%25AD%25EC%25A0%259C%2B%25ED%2595%2598%25EC%2598%2580%25EC%258A%25B5%25EB%258B%2588%25EB%258B%25A4.%26goto%3Dtbl_sql.php%26token%3D97616f6795c16ce1fd2396463e18d5cc&token=97616f6795c16ce1fd2396463e18d5cc" style="text-decoration:none;color:#0000ff;" target="_blank"><img src="http://bncfashion.co.nz/bnc/awolfenstein/themes/original/img/b_drop.png" title="삭제" alt="삭제" class="icon" width="16" height="16" style="vertical-align:middle;border:0px;margin:0px;"></a></td> <td align="right" class="nowrap" style="padding:.1em .5em;margin:.1em;vertical-align:top;">841</td> <td class="condition" style="padding:.1em .5em;margin:.1em;vertical-align:top;border:1px solid rgb(255,204,153);">1510_1</td> <td class="nowrap" style="padding:.1em .5em;margin:.1em;vertical-align:top;">2015-07-01</td></tr><tr class="even" style="background:#d5d5d5;"><td align="center" style="padding:.1em .5em;margin:.1em;vertical-align:top;"></td> <td align="center" style="padding:.1em .5em;margin:.1em;vertical-align:top;"><a target="_blank" href="http://bncfashion.co.nz/bnc/awolfenstein/tbl_change.php?db=pos&table=purchase&primary_key=%60purchase%60.%60id%60+%3D+834&clause_is_unique=1&sql_query=SELECT+id%2Cpurchase_num%2Cpurchase_date+%0D%0AFROM+purchase%0D%0AWHERE+purchase_num%0D%0AREGEXP+%27%5E%5B0-9%5D%7B3%7D.%2B%24%27+ORDER+BY+id+DESC+LIMIT+0%2C5&goto=sql.php&token=97616f6795c16ce1fd2396463e18d5cc" style="text-decoration:none;color:#0000ff;" target="_blank"><img src="http://bncfashion.co.nz/bnc/awolfenstein/themes/original/img/b_edit.png" title="수정" alt="수정" class="icon" width="16" height="16" style="vertical-align:middle;border:0px;margin:0px;"></a></td> <td align="center" style="padding:.1em .5em;margin:.1em;vertical-align:top;"><a target="_blank" href="http://bncfashion.co.nz/bnc/awolfenstein/sql.php?db=pos&table=purchase&sql_query=DELETE+FROM+%60pos%60.%60purchase%60+WHERE+%60purchase%60.%60id%60+%3D+834&zero_rows=%EC%84%A0%ED%83%9D%ED%95%9C+%EC%A4%84%28%EB%A0%88%EC%BD%94%EB%93%9C%29%EC%9D%84+%EC%82%AD%EC%A0%9C+%ED%95%98%EC%98%80%EC%8A%B5%EB%8B%88%EB%8B%A4.&goto=sql.php%3Fdb%3Dpos%26table%3Dpurchase%26sql_query%3DSELECT%2Bid%252Cpurchase_num%252Cpurchase_date%2B%250D%250AFROM%2Bpurchase%250D%250AWHERE%2Bpurchase_num%250D%250AREGEXP%2B%2527%255E%255B0-9%255D%257B3%257D.%252B%2524%2527%2BORDER%2BBY%2Bid%2BDESC%2BLIMIT%2B0%252C5%26zero_rows%3D%25EC%2584%25A0%25ED%2583%259D%25ED%2595%259C%2B%25EC%25A4%2584%2528%25EB%25A0%2588%25EC%25BD%2594%25EB%2593%259C%2529%25EC%259D%2584%2B%25EC%2582%25AD%25EC%25A0%259C%2B%25ED%2595%2598%25EC%2598%2580%25EC%258A%25B5%25EB%258B%2588%25EB%258B%25A4.%26goto%3Dtbl_sql.php%26token%3D97616f6795c16ce1fd2396463e18d5cc&token=97616f6795c16ce1fd2396463e18d5cc" style="text-decoration:none;color:#0000ff;" target="_blank"><img src="http://bncfashion.co.nz/bnc/awolfenstein/themes/original/img/b_drop.png" title="삭제" alt="삭제" class="icon" width="16" height="16" style="vertical-align:middle;border:0px;margin:0px;"></a></td> <td align="right" class="nowrap" style="padding:.1em .5em;margin:.1em;vertical-align:top;">834</td> <td class="condition" style="padding:.1em .5em;margin:.1em;vertical-align:top;border:1px solid rgb(255,204,153);">1509</td> <td class="nowrap" style="padding:.1em .5em;margin:.1em;vertical-align:top;">2015-06-17</td></tr><tr class="odd" style="background:#e5e5e5;"><td align="center" style="padding:.1em .5em;margin:.1em;vertical-align:top;"></td> <td align="center" style="padding:.1em .5em;margin:.1em;vertical-align:top;"><a target="_blank" href="http://bncfashion.co.nz/bnc/awolfenstein/tbl_change.php?db=pos&table=purchase&primary_key=%60purchase%60.%60id%60+%3D+830&clause_is_unique=1&sql_query=SELECT+id%2Cpurchase_num%2Cpurchase_date+%0D%0AFROM+purchase%0D%0AWHERE+purchase_num%0D%0AREGEXP+%27%5E%5B0-9%5D%7B3%7D.%2B%24%27+ORDER+BY+id+DESC+LIMIT+0%2C5&goto=sql.php&token=97616f6795c16ce1fd2396463e18d5cc" style="text-decoration:none;color:#0000ff;" target="_blank"><img src="http://bncfashion.co.nz/bnc/awolfenstein/themes/original/img/b_edit.png" title="수정" alt="수정" class="icon" width="16" height="16" style="vertical-align:middle;border:0px;margin:0px;"></a></td> <td align="center" style="padding:.1em .5em;margin:.1em;vertical-align:top;"><a target="_blank" href="http://bncfashion.co.nz/bnc/awolfenstein/sql.php?db=pos&table=purchase&sql_query=DELETE+FROM+%60pos%60.%60purchase%60+WHERE+%60purchase%60.%60id%60+%3D+830&zero_rows=%EC%84%A0%ED%83%9D%ED%95%9C+%EC%A4%84%28%EB%A0%88%EC%BD%94%EB%93%9C%29%EC%9D%84+%EC%82%AD%EC%A0%9C+%ED%95%98%EC%98%80%EC%8A%B5%EB%8B%88%EB%8B%A4.&goto=sql.php%3Fdb%3Dpos%26table%3Dpurchase%26sql_query%3DSELECT%2Bid%252Cpurchase_num%252Cpurchase_date%2B%250D%250AFROM%2Bpurchase%250D%250AWHERE%2Bpurchase_num%250D%250AREGEXP%2B%2527%255E%255B0-9%255D%257B3%257D.%252B%2524%2527%2BORDER%2BBY%2Bid%2BDESC%2BLIMIT%2B0%252C5%26zero_rows%3D%25EC%2584%25A0%25ED%2583%259D%25ED%2595%259C%2B%25EC%25A4%2584%2528%25EB%25A0%2588%25EC%25BD%2594%25EB%2593%259C%2529%25EC%259D%2584%2B%25EC%2582%25AD%25EC%25A0%259C%2B%25ED%2595%2598%25EC%2598%2580%25EC%258A%25B5%25EB%258B%2588%25EB%258B%25A4.%26goto%3Dtbl_sql.php%26token%3D97616f6795c16ce1fd2396463e18d5cc&token=97616f6795c16ce1fd2396463e18d5cc" style="text-decoration:none;color:#0000ff;" target="_blank"><img src="http://bncfashion.co.nz/bnc/awolfenstein/themes/original/img/b_drop.png" title="삭제" alt="삭제" class="icon" width="16" height="16" style="vertical-align:middle;border:0px;margin:0px;"></a></td> <td align="right" class="nowrap" style="padding:.1em .5em;margin:.1em;vertical-align:top;">830</td> <td class="condition" style="padding:.1em .5em;margin:.1em;vertical-align:top;border:1px solid rgb(255,204,153);">1508</td> <td class="nowrap" style="padding:.1em .5em;margin:.1em;vertical-align:top;">2015-06-03<br></td></tr></tbody></table></div> <div><br></div> <div>라고 쿼리를 만들었는데요. 제가 정규식은 좀 이해가 잘 안되서;;;</div> <div><br></div> <div>아무튼 내용은</div> <div><span style="font-size:9pt;line-height:1.5;"><br></span></div> <div><span style="font-size:9pt;line-height:1.5;">예를들어 1부터 100개의 데이터중에서 id 역순으로 5개를 뽑았습니다.</span></div> <div>근데 그 뽑힌 5개중에서 정렬을 다시 넣으려면 디비단에서 쿼리로 정렬이 가능할까요?</div> <div>id순으로 5개뽑힌걸 purchase_num 역순으로 정렬하고 싶습니다.</div> <div><br></div> <div>검색을 하려고 해도 키워드를 ;;; 뽑아낼 방법이 없어서 ㅜㅜ</div> <div><br></div> <div>고수님들의 답변을 기다릴게요 감사합니다 </div> <div><br></div> <div><br></div>
전직 게임회사 근로자는 웁니다.
댓글 분란 또는 분쟁 때문에 전체 댓글이 블라인드 처리되었습니다.