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 vote134 views1 answer
Add super privilege mysql
SQL
11 votes162 views2 answers
Import sql file laravel cmd
SQL
0 vote155 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
0 vote249 views1 answer
Why do we need data structure in sql
SQL
1 vote141 views1 answer
Sql server kill all connections
SQL
1 vote128 views1 answer
Sql into vs insert into
SQL
0 vote135 views1 answer
Convert excel into sqllite db using python
SQL
1 vote171 views1 answer
Psql client write to bash variable
SQL
0 vote121 views1 answer
Restart sql server command line linux
SQL
3 votes144 views1 answer
Mysql replace string in table
SQL