How to use OR WHERE with MySQL handler

[ashokkumar88]

I am using the MySQL handler. How can we use the OR operator in WHERE clause? For example we need to run the following query

SELECT id, name FROM product WHERE id = 5 OR year > '2010' OR (price BETWEEN '100' AND '200')

[ardatan]

You can have multiple aliases for each condition in OR statement;

{
   productFive: product(where: { id: '5' }) {
      id
      name
   }
   productNew: product(where: { year: '> 2010' }) {
     id
     name
    }
}

[ashokkumar88]

Thanks @ardatan Got it working now.