\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/p>\n
\ud3fc\uc5d0\uc11c \ub118\uc5b4 \uc624\ub294 \uac12 <\/p>\n
\uac80\uc0c9\uc5b4 : $SuyooName
\n\uc5f0\uc0b0\uc790 : AND \ub610\ub294 OR <\/p>\n
; \uac80\uc0c9\uc5b4 \ubcf5\uc218 \uac80\uc0c9 \uad6c\ubd84\uc790\ub294 \ucf64\ub9c8\ub85c (,)
\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/p>\n
\n $searchWord = explode(“,”,$SuyooName); <\/p>\n
$Query = “SELECT no,OldSuyooName,SuyooCode FROM TempSuyoo WHERE “;
\n $wCnt = count($searchWord);
\n while(list($key,$value) = each($searchWord))
\n {
\n if($key > 0)
\n {
\n if($value)
\n {
\n if($key < $wCnt) $Where .= \" $operator \";
\n }
\n }
\n if($value)
\n {
\n $Where .= ” OldSuyooName like ‘%$value%’ “;
\n }
\n } <\/p>\n
$Query .= $Where; <\/p>\n
\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/p>\n
\uc704 \ubc29\ubc95\uc73c\ub85c \ud558\uba74 \uac80\uc0c9\uc5b4 \uc785\ub825\uc2dc \ucffc\ub9ac\uc608 <\/p>\n
1. \uacbd\uc0c1\ub0a8\ub3c4,\ud558\ub3d9 <\/p>\n
SELECT no,OldSuyooName,SuyooCode FROM TempSuyoo
\n WHERE OldSuyooName like ‘%\uacbd\uc0c1\ub0a8\ub3c4%’ AND OldSuyooName like ‘%\ud558\ub3d9%’ <\/p>\n
2. \uacbd\uc0c1\ub0a8\ub3c4, <\/p>\n
SELECT no,OldSuyooName,SuyooCode FROM TempSuyoo
\n WHERE OldSuyooName like ‘%\uacbd\uc0c1\ub0a8\ub3c4%’ <\/p>\n
3. \uacbd\uc0c1\ub0a8\ub3c4,,\ud558\ub3d9 <\/p>\n
SELECT no,OldSuyooName,SuyooCode FROM TempSuyoo
\n WHERE OldSuyooName like ‘%\uacbd\uc0c1\ub0a8\ub3c4%’ AND OldSuyooName like ‘%\ud558\ub3d9%’ <\/p>\n
\uc774\ub807\uac8c \ud574\ub3c4 \uc2e4\uc81c \uc874\uc7ac\ud558\ub294 \uac80\uc0c9\uc5b4\uc5d0 \ud574\ub2f9\ud558\ub294 \ucffc\ub9ac\ub9cc \uc0dd\uc131\uc744 \ud569\ub2c8\ub2e4. <\/p>\n
\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/p>\n","protected":false},"excerpt":{"rendered":"
\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ \ud3fc\uc5d0\uc11c \ub118\uc5b4 \uc624\ub294 \uac12 \uac80\uc0c9\uc5b4 : $SuyooName \uc5f0\uc0b0\uc790 : AND \ub610\ub294 OR ; \uac80\uc0c9\uc5b4 \ubcf5\uc218 \uac80\uc0c9 \uad6c\ubd84\uc790\ub294 \ucf64\ub9c8\ub85c (,) \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ $searchWord = explode(“,”,$SuyooName); $Query = “SELECT no,OldSuyooName,SuyooCode FROM TempSuyoo WHERE “; $wCnt = count($searchWord); while(list($key,$value) = each($searchWord)) { if($key > 0) { if($value) { if($key < $wCnt) $Where .= \" $operator \"; } } […]\n<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[51],"tags":[],"class_list":["post-352","post","type-post","status-publish","format-standard","hentry","category-papa-php"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts\/352","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=352"}],"version-history":[{"count":0,"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts\/352\/revisions"}],"wp:attachment":[{"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=352"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=352"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=352"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}