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 vote195 views1 answer
Influxdb list all tags for a measurement
SQL
0 vote175 views1 answer
SQL add a totals of differemt rows of the same id
SQL
4 votes169 views1 answer
Update table from another table oracle
SQL
0 vote161 views1 answer
Mysql select where field like in list
SQL
0 vote180 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
10 votes192 views6 answers
Sql between
SQL
4 votes172 views1 answer
Mysql biginteger size
SQL
-1 vote185 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
0 vote178 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
0 vote161 views1 answer
Sql insert tuple
SQL