Write a condition inside a sql query

Question

I have a column call isDifFromother which is hold either 1 or 2 (default it is set to 0). when i updating a row, i want to set 2 if the isDifFromother value is having 0. if its having 1 i want to keep it as it is.

How can i check that condition inside my update query.

here is my query...,

UPDATE `customer` SET `name`='" + name + "', `isPackage`='" + packageID + "', `billing_ID`='" + biling_ID + "', `isDifFromother`=IF customer.isDifFromother = '1'  THEN '2' END IF WHERE `id`='" + cusID + "';

but its embedded with errors.

when isDifFromother=0 you want to update isDifFromother as 2 rite ? update customer set isDifFromother=2 where isDifFromother=0 — Arul Sidthan
– Arul Sidthan, Commented Mar 6, 2015 at 10:13

Abhik Chakraborty · Accepted Answer · 2015-03-06 09:38:06Z

1

The if statement is not correct and it should be as

UPDATE `customer` SET `name`='" + name + "', `isPackage`='" + packageID + "', `billing_ID`='" + biling_ID + "', `isDifFromother`=IF(customer.isDifFromother = '0','2',customer.isDifFromother) WHERE `id`='" + cusID + "';

The following condition

`isDifFromother`=IF(customer.isDifFromother = '0','2',customer.isDifFromother)

sets isDifFromother = 2 if its 0 else remain as it is.

edited Mar 6, 2015 at 9:38

answered Mar 6, 2015 at 8:57

Abhik Chakraborty

44.9k6 gold badges56 silver badges63 bronze badges

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

2 Comments

Abhik Chakraborty Over a year ago

Are you getting any error ? or its not updating the data ?

Abhik Chakraborty Over a year ago

Have you added like isDifFromother=IF(customer.isDifFromother = '0','2',customer.isDifFromother)

Collectives™ on Stack Overflow

Write a condition inside a sql query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related