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

6 votes335 views3 answers
POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE
SQL
3 votes324 views2 answers
Monthname sql
SQL
2 votes303 views1 answer
Username sql
SQL
0 vote627 views1 answer
How to connect .sql data set to powerbi
SQL
0 vote341 views2 answers
Oracle create tablespace autoextend
SQL
0 vote375 views1 answer
Sql basic commands
SQL
1 vote322 views1 answer
How to delete a record from sqlite in android
SQL
2 votes322 views3 answers
How to get second highest salary in each department in sql
SQL
2 votes323 views2 answers
Change varchar length mysql
SQL
24 votes334 views4 answers
Mysql datetime
SQL