You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user-java@ibatis.apache.org by Ra...@emc.com on 2005/10/31 20:43:53 UTC

Setting the LIMIT in a MYSQL select statement

Hi,

Is there any way to dynamically alter the LIMIT clause in Mysql with IBATIS?

Say for ex,

Select * from User LIMIT #row_number#, 1;

To get a particular row from the table.

Thanks,

Mithra Rajah

Re: Setting the LIMIT in a MYSQL select statement

Posted by Larry Meadors <lm...@apache.org>.

Select * from User LIMIT $row_number$, 1;

On 10/31/05, Rajah_Mithra@emc.com <Ra...@emc.com> wrote:
>
> Hi,
>
> Is there any way to dynamically alter the LIMIT clause in Mysql with IBATIS?
>
> Say for ex,
>
> Select * from User LIMIT #row_number#, 1;
>
> To get a particular row from the table.
>
> Thanks,
>
> Mithra Rajah
>
>
>