»Ë»Ñ Æ÷·³
°³¹ßÀÚÆ÷·³ ÀÔ´Ï´Ù.
  • ºÏ¸¶Å© ¾ÆÀÌÄÜ

mysql Á¶°Ç Á¤·Ä4

  • [* ºñȸ¿ø *]
  • µî·ÏÀÏ 2015-10-29 11:26
  • Á¶È¸¼ö 1875

                select * from kiat_rd_tech t
                join kiat_rd r
                on r.pjt_orig_no = t.pjt_orig_no
                where r.user_id = #{userId}
                and r.pjt_orig_no LIKE CONCAT("%", #{pjtOrigNo}, "%")
                and t.pjt_tech_no LIKE CONCAT("%", #{pjt_tech_no_search}, "%")
                and r.pjt_name_kr LIKE CONCAT("%", #{pjt_name_kr_search}, "%")
                and r.pjt_detail_no LIKE CONCAT("%", #{pjt_detail_no_search}, "%")
                and r.busi_name LIKE CONCAT("%", #{busi_name_search}, "%")
                and r.gov_name LIKE CONCAT("%", #{gov_name_search}, "%")
                and r.facillity_name LIKE CONCAT("%", #{facillity_name_search}, "%")
                and r.research_attach_name LIKE CONCAT("%", #{research_attach_name_search}, "%")
                and t.write_status LIKE CONCAT("%", #{write_status_search}, "%")
                and t.approval_status LIKE CONCAT("%", #{approval_status_search}, "%")
                and t.tech_move_check LIKE CONCAT("%", #{tech_move_check_search}, "%")
                if test="range == '±â¼úÃß°¡Á¤·Ä'"
                        order by r.sub_regi_date DESC
                /if
                if test="range == 'ÀÔ·ÂÁ¤·Ä'"
                        order by t.tech_regi_date DESC
                /if
                limit #{s},#{l};

ÀÌ·±½ÄÀ¸·Î ¹Þ¾Æ¿Â range °ª¿¡ µû¶ó ´Ù¸¥ Á¤·ÄÀ» ÇÏ°í ½ÍÀºµ¥ °ªÀº ³Ñ¾î¿À°í ¿À·ùµµ ¾ø°í
if ¹®ÀÌ Á¦´ë·Î ¾Èµ¹¾Æ°¡´Â°Å °°Àºµ¥.. ¾î¶»°Ô ÇØ°áÇϸé ÁÁÀ»±î¿ä?

0
ÃßõÇϱ⠴ٸ¥ÀÇ°ß 0
|
°øÀ¯¹öÆ°

´Ù¸¥ÀÇ°ß 0 Ãßõ 0 [* ºñȸ¿ø *]

´Ù¸¥ÀÇ°ß 0 Ãßõ 0 [* ºñȸ¿ø *]

´Ù¸¥ÀÇ°ß 0 Ãßõ 0 ¹Ö±¸¹Ö±¸Âô

´Ù¸¥ÀÇ°ß 0 Ãßõ 0 [* ºñȸ¿ø *]
  • ¾Ë¸² ¿å¼³, »óó ÁÙ ¼ö ÀÖ´Â ¾ÇÇÃÀº »ï°¡ÁÖ¼¼¿ä.
©¹æ »çÁø  
¡â ÀÌÀü±Û¡ä ´ÙÀ½±Û ¸ñ·Ïº¸±â