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 vote139 views1 answer
Mysql query problems and solutions
SQL
0 vote143 views1 answer
Add two days to current date in sql when creating tables
SQL
0 vote141 views2 answers
How to drop mili second in sql
SQL
0 vote137 views1 answer
Mysql count with two joins
SQL
0 vote125 views1 answer
Nth max in my sql
SQL
0 vote132 views1 answer
Postgres - Login and connect as default user
SQL
2 votes149 views3 answers
Oracle show column of table
SQL
4 votes129 views1 answer
Oracle show error line number
SQL
2 votes137 views2 answers
How to rename column name in sql server using query
SQL
0 vote145 views1 answer
T-SQL - Where Used List (Table/View)
SQL