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 vote249 views1 answer
Index a database column sql
SQL
0 vote258 views1 answer
Except in sql alchemy
SQL
1 vote265 views2 answers
Begin transaction in sql
SQL
6 votes315 views3 answers
What is where in sql
SQL
0 vote251 views1 answer
Where case insensitive like mysql
SQL
0 vote263 views2 answers
Mysql row_number() example
SQL
1 vote258 views2 answers
T sql get foreign key
SQL
2 votes246 views2 answers
Set database timezone mysql
SQL
0 vote254 views1 answer
Import sql dump into postgresql database
SQL
0 vote256 views1 answer
Mssql check if date is greater than today
SQL