Open makalin opened 1 year ago
NOT LIKE does not list NULL items so I'm replacing
WHERE datas NOT LIKE '%2023%' to WHERE datas IS NULL OR datas NOT LIKE '%2023%'
but to get same results in single query there a shorter way like
WHERE (datas LIKE '%2023%') IS NOT TRUE
so is there possible way to add in_not_true and is_true?
NOT LIKE does not list NULL items so I'm replacing
WHERE datas NOT LIKE '%2023%' to WHERE datas IS NULL OR datas NOT LIKE '%2023%'
but to get same results in single query there a shorter way like
WHERE (datas LIKE '%2023%') IS NOT TRUE
so is there possible way to add in_not_true and is_true?