mysql use the verify condition in the query browser

set @byFlag = 'week';
set @sourceFlag= 'Web';

 

SELECT IF(@byFlag = 'week',2,3);

SELECT
  CASE @byFlag WHEN 'week' THEN 'one'
         WHEN 2 THEN 'two'
         ELSE 'more' END;

 

SELECT
  CASE @byFlag
  WHEN 'week' THEN ( select 'one')
  WHEN 'month' THEN 'two'
  ELSE 'more' END;