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 vote223 views1 answer
Postgres read table structure
SQL
0 vote210 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
0 vote246 views1 answer
How to pass list as parameter in SQL query
SQL
0 vote222 views2 answers
Dbms transaction tutorialspoint
SQL
1 vote203 views1 answer
How to give access to database in postgresql server to another user
SQL
2 votes223 views1 answer
Sql as
SQL
0 vote222 views1 answer
Zerar auto increment mysql
SQL
1 vote235 views1 answer
Quit mysql
SQL
0 vote226 views1 answer
Data directory postgresql
SQL
0 vote236 views1 answer
Add created and updatedAt fields in mysql
SQL