Re: select where column = @variable

[Jan Stembera]

I just wanted to add that this also works, HOWEVER it never cycles through the entire cursor fetch:


SET @SQL1 := concat('select count(*) into @sql_found FROM state_data where sql_handle =''',@digest,'''');
PREPARE stmt FROM @SQl1;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;