The manual states:
"Normally, you don't have to lock tables, as all single UPDATE statements are atomic;
no other thread can interfere with any other currently executing SQL statement."
Does this hold true for INSERT ... SELECT statements as well? Can I assume that
multiple records inserted in
How about this:
update table
set answer = concat_ws("," ,
if(left(columnA,1)="*",substring(columnA,2),""),
if(left(columnB,1)="*",substring(columnB,2),""),
if(left(columnC,1)="*",substring(columnC,2),"") )
Greg
> I've got a 700-question multiple choice quiz th
