(JDBC) Mysql query with if statement and multiple conditions

Question

What is the proper syntax for a mysql-java statement such as this one ?

PreparedStatement st =connection.prepareStatement("SELECT Name, Value, Quantity FROM sales if (type=='Purchase' AND state=='confirmed') OR (type=='Sale' AND state=='not confirmed'))  ;

Gordon Linoff · Accepted Answer · 2016-05-28 15:44:06Z

1

The SQL would look like:

SELECT Name, Value, Quantity
FROM sales 
WHERE (type = 'Purchase' AND state = 'confirmed') OR
      (type = 'Sale' AND state = 'not confirmed');

answered May 28, 2016 at 15:44

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mureinik · Accepted Answer · 2016-05-28 15:46:37Z

0

The condition should be in a where clause, not anifclause, and the equality check operator in SQL is=, not==`. So:

SELECT Name, Value, Quantity 
FROM   sales 
WHERe  (type = 'Purchase' AND state = 'confirmed') OR 
       (type = 'Sale' AND state = 'not confirmed')

answered May 28, 2016 at 15:46

Mureinik

316k54 gold badges400 silver badges405 bronze badges

Collectives™ on Stack Overflow

(JDBC) Mysql query with if statement and multiple conditions

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related