On Aug 15, 2:32 pm, Camelback <sce...@yahoo.com> wrote:
> Hello
>
> I'm new to SQL -
>
> I'm trying to update multiple rows in a table.
>
> Table -
> Column values - ID | Name | IsCrazy
>
> This is my query
>
> UPDATE table
> SET IsCrazy = 'True'
> WHERE ID = 1,20,3,4,50
>
> I am having a problem with the "WHERE ID =" part.
>
> I have multiple id's that I need to update. How do i do this?
>
> Thanks in advance!

On Aug 15, 2:34 pm, Jason Lepack <jlep...@gmail.com> wrote:
> UPDATE table
> SET IsCrazy = 'True'
> WHERE ID in(1,20,3,4,50)
>
> Cheers,
> Jason Lepack
>
> On Aug 15, 2:32 pm, Camelback <sce...@yahoo.com> wrote:
>
> > Hello
>
> > I'm new to SQL -
>
> > I'm trying to update multiple rows in a table.
>
> > Table -
> > Column values - ID | Name | IsCrazy
>
> > This is my query
>
> > UPDATE table
> > SET IsCrazy = 'True'
> > WHERE ID = 1,20,3,4,50
>
> > I am having a problem with the "WHERE ID =" part.
>
> > I have multiple id's that I need to update. How do i do this?
>
> > Thanks in advance!