Search code examples
sqlibatis

How to implement the greater than or equal SQL statement in iBatis?


Let's say in my sql statement I want to do:

WHERE numberOfCookies >= 10 

How do I do this in iBatis?


Solution

  • Because the SQL is written in xml, you cannot just use the symbol ">", you need to write it as:

    WHERE numberOfCookies >= 10
    

    Update:

    > for greater than

    < for less than