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 votes129 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL
2 votes115 views2 answers
Postgresql get table names
SQL
2 votes109 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
1 vote118 views2 answers
Mysql trim spaces
SQL
79 votes273 views6 answers
Grepper code
SQL
1 vote111 views1 answer
Altering the column name in MySQL to have a default value
SQL
0 vote100 views1 answer
Create function syntax sql server
SQL
0 vote164 views1 answer
Insert query return id mysql
SQL
8 votes107 views2 answers
Phpmyadmin default password
SQL
0 vote112 views1 answer
Top 3 salary in sql
SQL