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

3 votes170 views2 answers
How to View column names of a table in SQL
SQL
6 votes183 views2 answers
Mysql first day of month
SQL
12 votes207 views1 answer
Run mysql instance in docker
SQL
1 vote201 views1 answer
Spark sql convert string to date
SQL
7 votes187 views5 answers
Oracle alter table
SQL
5 votes181 views1 answer
Oracle sysdate
SQL
5 votes183 views1 answer
Oracle list days between two dates
SQL
0 vote178 views1 answer
Display first three characters sql
SQL
1 vote188 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
1 vote189 views1 answer
Mysql select and count left join
SQL