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 vote171 views2 answers
Plsql regex match whole word
SQL
0 vote198 views1 answer
"Hello User Name"
SQL
0 vote124 views1 answer
Check if has alpha characters sql
SQL
0 vote188 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
0 vote178 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
1 vote171 views1 answer
Sql server get users
SQL
0 vote190 views2 answers
Amazon linux postgresql client
SQL
7 votes193 views4 answers
Index in mysql
SQL
0 vote169 views1 answer
Postgresql if else endif
SQL
6 votes176 views4 answers
Remove spaces sql server
SQL