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 vote187 views1 answer
Remove from table where
SQL
0 vote183 views1 answer
C# datetime to sql server datetime
SQL
2 votes327 views1 answer
Tsql copy table
SQL
3 votes195 views1 answer
Sql cast to integer
SQL
3 votes189 views2 answers
Postgresql remove not null constraint
SQL
4 votes287 views1 answer
Select first and last row sql
SQL
13 votes185 views5 answers
Select last row mysql
SQL
0 vote221 views1 answer
Drush run sql select
SQL
7 votes211 views2 answers
Postgres concat
SQL
1 vote204 views2 answers
Mysql error 1215
SQL