论坛 › MySQL运维 › mysql use the verify condition in the query browser

haishi 发表于 2016-10-21 02:33:36

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;

查看完整版本: mysql use the verify condition in the query browser