Does this work (update + in )

Databases
1

Will this work?

UPDATE contacts
SET contactid = 15
WHERE contactid = 27
AND sessionid IN ( 12,43,89,101 )

Or do I need to do a loop with the sessionids and do individual updates?

2

Did you try it?

3

Not yet. This is an existing database/app that I’m building a back end for, so I didn’t want to fiddle with the data too badly with the app being in use. But I think I’ll just make a backup of the database and try.

4

It works! :slight_smile:

Now in a year when I forget and have this question again, I’ll find this thread and know. :wink:

1 Like
5

my stock response has always been –

used that line a dozen times or more with Double D Debbie

(can’t honestly say i miss her, but i wonder how she’s doing now that she doesn’t have sitepoint to answer her thousands of questions)

2 Likes
6

I tried to channel my inner Rudy…missed the mark. I must be out of practice.

1 Like
7

I had no idea she left!

8

If you’re talking about Rudy… it is a he. Just in case :smiley:

1 Like
9

lol, well hopefully no one finds my questions too annoying!

10

Most of the questions are not annoying… The only thing that can be annoying is someone that expects you to do their homework for them. We’re happy to help but doing someone else’s work… well, that’s different :smile:

11

that’s debbie in a nutshell

2 Likes
12

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.