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

11 votes200 views5 answers
Laravel db facade
SQL
0 vote178 views1 answer
Alasql delete column
SQL
0 vote194 views1 answer
MySql Modify Increment
SQL
0 vote179 views1 answer
Match end of string regex sql
SQL
17 votes197 views6 answers
Change column name in sql
SQL
1 vote246 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
0 vote219 views1 answer
Sql character index
SQL
0 vote173 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL
1 vote224 views1 answer
Oracle drop chain step
SQL
4 votes224 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL