How to use sql key word ‘in’ with SQL Builder Class

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

How to use sql key word ‘in’ with SQL Builder Class

demo
I want to execute an SQL 

select * from user where id in (1,2,3,4)

how to use SQL Builder Class  to build this SQL 

--
You received this message because you are subscribed to the Google Groups "mybatis-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/mybatis-user/ef182fdf-b846-48fb-b8bb-7471929e30ee%40googlegroups.com.
Reply | Threaded
Open this post in threaded view
|

Re: How to use sql key word ‘in’ with SQL Builder Class

Guy Rouillier-2
Have you checked MyBatis User Guild for discussions and examples of SqlBuilder?  But beware before proceeding of this comment in the current version of the guild: "SelectBuilder and SqlBuilder classes have  been deprecated."  I've never used SqlBuilder myself, but after reading this, doesn't sound like a good idea to do any new code with this approach.

--
Guy Rouillier

On 11/29/2019 9:41:44 PM, "demo" <[hidden email]> wrote:

I want to execute an SQL 

select * from user where id in (1,2,3,4)

how to use SQL Builder Class  to build this SQL 

--
You received this message because you are subscribed to the Google Groups "mybatis-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/mybatis-user/ef182fdf-b846-48fb-b8bb-7471929e30ee%40googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "mybatis-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/mybatis-user/embea504b0-5faa-4363-8c0b-ff1b08db3d0a%40asus.