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 vote150 views1 answer
Auto increment psql not primary key
SQL
1 vote106 views1 answer
Oracle character set
SQL
2 votes144 views1 answer
Oracle calculated column
SQL
1 vote145 views2 answers
Mysql order by date asc null last
SQL
4 votes141 views2 answers
Mysql how to change default charset
SQL
0 vote144 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
12 votes172 views6 answers
Change mysql root password
SQL
1 vote157 views1 answer
Find a column in all tables postgres
SQL
5 votes138 views1 answer
Mysql add user with all privileges
SQL
0 vote153 views1 answer
Recursive query herarchical data sql server
SQL