ขอทราบวิธีการ COUNT ข้อมูลแบบ SUBSTRING โดยมีข้อมูลอยู่ในฟิลเดียว

#MySql
select
  sum( if( UserDefine1 = '07:30 - 19:00', 1, 0)) as `07:30-19:00`
, sum( if( UserDefine1 = '19:00 - 06:30', 1, 0)) as `19:00-06:30` 
from ..... 
where .....

#MsSql
select
  sum( iif( UserDefine1 = '07:30 - 19:00', 1, 0)) as "07:30-19:00"
, sum( iif( UserDefine1 = '19:00 - 06:30', 1, 0)) as "19:00-06:30" 
from ..... 
where .....

select
  count( case when UserDefine1 = '07:30 - 19:00' then 1 end ) as `07:30-19:00`
, count( case when UserDefine1 = '19:00 - 06:30' then 1 end ) as `19:00-06:30` 
from ..... 
where .....

select
  count( case when UserDefine1 = '07:30 - 19:00' then 1 else null end ) as `07:30-19:00`
, count( case when UserDefine1 = '19:00 - 06:30' then 1 else null end ) as `19:00-06:30` 
from ..... 
where .....