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 vote316 views1 answer
Add 10 to all numbers in a column sql
SQL
0 vote261 views1 answer
Heavy table in mysql
SQL
0 vote299 views1 answer
Oracle table privileges
SQL
14 votes294 views3 answers
Inner join sql oracle
SQL
3 votes229 views2 answers
Mysql sum with condition
SQL
5 votes260 views6 answers
Sql add days to date
SQL
0 vote276 views1 answer
Oracle service name view
SQL
4 votes313 views3 answers
Sql find second highest salary employee
SQL
0 vote338 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL
0 vote324 views1 answer
Why do we need data structure in sql
SQL