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

11 votes371 views5 answers
Laravel db facade
SQL
7 votes344 views2 answers
What is sql clause
SQL
7 votes318 views1 answer
Oracle set sequence value to max(id)
SQL
1 vote344 views1 answer
Postgresql round double precision
SQL
1 vote303 views2 answers
Into sql
SQL
12 votes411 views6 answers
Change mysql root password
SQL
0 vote366 views1 answer
Command to give readonly access to a postgres sql user
SQL
-1 vote348 views1 answer
Sql show custom constraints
SQL
0 vote337 views1 answer
Add multiple field in table sql
SQL
0 vote348 views1 answer
USING THE NOT CONDITION IN SQL
SQL