sql-board.xml ( 해당 부분 수정 ) > SPRINGBOOT

• 목록

<!-- search -->

<select id="selectSearchList" resultType="web.dto.BoardDto">

  <![CDATA[

select *,(select stored_file_path from t_file where board_idx = t_board.board_idx limit 1) as file01 from t_board where deleted_yn='N' 

  ]]> 

<include refid="search"></include> 

  <![CDATA[

order by board_idx desc limit #{pageStart},#{perPageNum}

  ]]>

</select>