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

2 votes132 views2 answers
How to get capital letter first in sql
SQL
0 vote105 views1 answer
Postgresql subquery
SQL
3 votes141 views2 answers
Oracle sql truncate table
SQL
0 vote166 views1 answer
Error code 1451 sql
SQL
0 vote296 views1 answer
The differnece between to values in sql
SQL
8 votes173 views1 answer
My sql version
SQL
0 vote142 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
4 votes169 views3 answers
NOT NULL SQL
SQL
0 vote156 views1 answer
Createdb with postgresql on ubuntu
SQL
3 votes175 views2 answers
How to modify rows in SQL Server
SQL