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 vote110 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
0 vote117 views1 answer
Last date for each user sql
SQL
0 vote118 views1 answer
Get clob size oracle
SQL
2 votes113 views1 answer
Oracle cpu per session
SQL
0 vote125 views1 answer
Mysql milliseconds
SQL
0 vote118 views1 answer
Mysql uuid
SQL
12 votes121 views5 answers
Rename table in mysql
SQL
0 vote122 views1 answer
Access mysql database docker container shell
SQL
60 votes212 views6 answers
Add column in sql
SQL
0 vote119 views1 answer
Sqlalchemy get ids
SQL