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

1 vote369 views1 answer
Drop table if exists oracle
SQL
0 vote329 views1 answer
Microsoft word insert sql code
SQL
1 vote294 views1 answer
Postgres reset auto increment
SQL
0 vote353 views1 answer
Change magento database url usimg musql
SQL
1 vote382 views1 answer
Mysql select row max date
SQL
9 votes323 views3 answers
Mysql get last id
SQL
0 vote377 views1 answer
Postgres dump sql insert
SQL
8 votes353 views1 answer
How to remove tables from postgresql
SQL
0 vote342 views1 answer
Trigger value from maltiple table to single table mysql
SQL
1 vote313 views2 answers
Into sql
SQL