On Friday, March 22, 2024, Jamie Thompson <jthompson(dot)neuk(at)gmail(dot)com> wrote:
>
> Earlier today, I was running some sql for someone which they had submitted
> as:
> > UPDATE tablename SET col1 = val1 AND col2 = val2 WHERE id = X
>
I presume these columns are booleans. So you wrote something like:
Set col1 = ( true and false = true )
Which in this case must coincidentally have produced whatever boolean value
already existed in col1.
David J.