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

1 vote297 views1 answer
How much every mysql database record takes from diskspace
SQL
0 vote314 views1 answer
Sql pad left 0
SQL
3 votes301 views1 answer
Sql server check version
SQL
1 vote317 views1 answer
Oracle turn off constraint
SQL
-1 vote343 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
1 vote345 views1 answer
Oracle create program if not exists
SQL
0 vote289 views1 answer
Sql where time stamp is in between
SQL
2 votes316 views3 answers
Sql interview query questions
SQL
0 vote309 views1 answer
Mysql date format unix timestamp
SQL
0 vote320 views1 answer
Mysql failed to login as root@localhost
SQL