Re: Interesting query outcomes

Johann Klammer <[email protected]> Thu, 27 Aug 2020 18:45:43 +0200

Newsgroups	comp.databases.mysql
Organization	Aioe.org NNTP Server
Message-ID	<[email protected]>

On 08/18/2020 10:33 PM, Joe wrote:
> select CASE WHEN (TNAM is NULL || TNAM='') THEN 'default' 
>                        ELSE TNAM END,  count(1)
>  from ITEMS group by 1;

What happens if you do:

select CASE WHEN (TNAM is NULL || TNAM=''|| TNAM='default') THEN 'default' 
                       ELSE TNAM END,  count(1)
 from ITEMS group by 1;