Update sql column based on another column from the same row

Question

I'm using JDBC as my servlet and trying manipulate to my database.

id | color | description |    
1  | blue  | fasfsfafssf |
2  | red   | afsafasfasf |

how can I choose all rows where color=blue and change the description based on the id? for now, i have soemthing along the lines:

SELECT id, description FROM table WHERE color="blue"

String description = manipulate(resultset.getInt(id)) //resultset is from executing the    query

Now how do i update the description of the same row with description?

hopefully that made sense

EDIT: The problem is that the way that description changes will be based on the ID (therefore the manipulate method).

We're going to possibly need some more information. First, what do you expect to get - this is a big one and will help a lot. Second, are you actually trying to manipulate (change) the data or just change the value when you select it but leave it intact in the database? — Brandon Buck
– Brandon Buck, Commented Oct 17, 2013 at 23:04
The problem is that the way that description changes will be based on the ID (therefore the manipulate method). — Lor
– Lor, Commented Oct 17, 2013 at 23:26
That doesn't tell me how it changes. What kind of change? Are you trying to do something like id - description or repeat the description... I'm asking what you expect the result to be. And if you expect the original data to remain intact. Those are two very big questions that will impact the answer. — Brandon Buck
– Brandon Buck, Commented Oct 18, 2013 at 2:14
Based how? How will you derive the description from the id? Please be specific so that someone can give you a solution. — Dawood ibn Kareem
– Dawood ibn Kareem, Commented Oct 18, 2013 at 3:04

Dawood ibn Kareem · Accepted Answer · 2013-10-17 23:01:18Z

1

You don't need to use the id. Try this.

update table set description = 'fluffy' where color = 'blue';

answered Oct 17, 2013 at 23:01

Dawood ibn Kareem

80.2k15 gold badges103 silver badges112 bronze badges

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

Collectives™ on Stack Overflow

Update sql column based on another column from the same row

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related