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 vote132 views2 answers
Mysql regexp match word
SQL
8 votes136 views2 answers
Update sql server from another table
SQL
2 votes149 views2 answers
Postgresql search all tables for column name
SQL
5 votes132 views1 answer
List foreign key oracle
SQL
0 vote151 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
0 vote162 views1 answer
Nuget sqllite-net-pcl
SQL
11 votes146 views2 answers
Oracle saurce code
SQL
7 votes142 views4 answers
How to reset the identity column in sql server
SQL
0 vote194 views1 answer
Restart serial number for postgres
SQL
-1 vote138 views5 answers
Online sql to linq generator
SQL