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 vote336 views1 answer
Sql datum formatieren
SQL
1 vote281 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
1 vote310 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
0 vote287 views1 answer
Enable full text search mysql
SQL
0 vote289 views1 answer
Insert output identity
SQL
0 vote277 views1 answer
Hive batch drop table
SQL
-1 vote283 views1 answer
Mysql select all columns and specific fields as
SQL
2 votes282 views1 answer
Sql server conection string
SQL
31 votes288 views3 answers
SQL Server change column data type
SQL
0 vote330 views1 answer
Mariadb change column type
SQL