Mysql isshow

<sql id="criteria"> <trim prefix="and(" suffix=") " prefixOverrides="OR"> <foreach item='type' collection="typeArr"> <trim prefix="OR"> <choose> <when test="type== 'T'.toString()"> post_title like '%' || #{keyword}||'%' </when> <when test="type== 'C'.toString()"> post_content like '%' || #{keyword}||'%' </when> <when test="type== 'W'.toString()"> post_writer like '%' || #{keyword}||'%' </when> </choose> </trim> </foreach> </trim> </sql> <select id="selectboardList" resultType="board"> select * from (select rownum rno,b.* from board_post b where isshow != 'N' <include refid="criteria"></include> order by post_no desc ) where rno between (#{pageNum}-1)*#{amount}+1 and (#{pageNum})*#{amount} </select>

Similar codes

0 vote273 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
1 vote291 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
1 vote286 views1 answer
Setval pgsql
SQL
0 vote262 views1 answer
Google cloud sql postgres url example
SQL
1 vote264 views1 answer
Error code 1055
SQL
6 votes294 views3 answers
Mysql remove user privileges
SQL
17 votes257 views6 answers
Sql current date
SQL
6 votes290 views4 answers
Mysql group by month
SQL
0 vote278 views1 answer
Select from column mysql
SQL
0 vote291 views1 answer
Procedure excute monthly oracle
SQL