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 vote367 views3 answers
Union in sql
SQL
0 vote358 views1 answer
Make a socket server to detect changes in mysql
SQL
0 vote407 views1 answer
Mysql get first 2 characters of string
SQL
5 votes350 views1 answer
Oracle columns in all_tables
SQL
1 vote366 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL
18 votes364 views6 answers
Drop table if exists
SQL
2 votes360 views1 answer
Sqlite insert if not exists
SQL
1 vote372 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL
1 vote355 views1 answer
Psql autocomplete for mac brew install
SQL
5 votes334 views1 answer
Mysql select greater than yesterday
SQL