> > insert into table select ... where col1 = 'value'
> >
>
> this is working but I am inserting values directly and not by select. eg:
>
> insert into table values(x,x,x)
> and not
> insert into table select * from table2
>
insert into table select (x, x, x) where col1 = 'value'