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 vote269 views1 answer
Set a value by excuting stored procedure
SQL
38 votes310 views6 answers
Alter table mysql
SQL
0 vote277 views1 answer
How to set sql_mode for a query in CI model
SQL
3 votes247 views3 answers
Print in pl sql
SQL
0 vote241 views1 answer
Import all databases mysql
SQL
11 votes240 views2 answers
Sql between date range
SQL
2 votes261 views1 answer
Sql create database
SQL
-1 vote282 views1 answer
Minus vs except in sql
SQL
1 vote278 views1 answer
Random name function in mysql for nvarchar
SQL
0 vote261 views1 answer
Turn on foreign keys check mysql
SQL