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 vote193 views1 answer
Copied text from internet not inserting in mysql
SQL
0 vote168 views1 answer
Delete all rows from table sqlite
SQL
1 vote208 views1 answer
Select not matching data with join table
SQL
5 votes199 views2 answers
Mysql drop table cascade
SQL
0 vote202 views1 answer
Oracle list of long running queries
SQL
0 vote217 views1 answer
Change date format in oracle query
SQL
-1 vote204 views1 answer
Sql add column bit
SQL
0 vote239 views1 answer
How to define a non primary composite key in sql
SQL
2 votes198 views1 answer
Sql alchemy or
SQL
1 vote198 views3 answers
How to truncate table with foreign key constraint
SQL