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 vote131 views1 answer
Datagrip execute procedure
SQL
0 vote122 views1 answer
Mysql search multiple tables
SQL
0 vote129 views1 answer
Mysql date equals to current_date plus days
SQL
0 vote130 views1 answer
How to connect to mysql in ef 6
SQL
1 vote145 views2 answers
One to one and one to many relationship
SQL
5 votes126 views1 answer
Sql add column after another
SQL
2 votes129 views1 answer
How to check grants on a package in oracle
SQL
22 votes120 views3 answers
Join three tables sql
SQL
0 vote121 views1 answer
Postgres populate table from another table
SQL
16 votes132 views3 answers
Update table from another table
SQL