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

5 votes209 views1 answer
Get table columns from sql
SQL
0 vote177 views1 answer
Timestamp(0) postgresql
SQL
0 vote202 views1 answer
Insert output identity
SQL
0 vote205 views1 answer
Create a plsql object
SQL
0 vote170 views1 answer
Pl sql disable trigger
SQL
2 votes207 views3 answers
Current setting postgres timezone
SQL
1 vote176 views1 answer
Flask sqlalchemy filter multiple conditions
SQL
-1 vote176 views1 answer
How to dump .csv file into mysql
SQL
11 votes197 views4 answers
Reset identity column values in sql server
SQL
2 votes183 views1 answer
How to find table table in stored procedure sql server
SQL