Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tbl(name text);
INSERT INTO tbl VALUES
  ('ubereats')
, ('uber eats')
, ('uber-eats')
, ('uber* eats')
, ('uber *eats')
, ('uber sucks')
, ('uberg has seats')  -- false filter match?
, ('taxi');
8 rows affected

SELECT * FROM  tbl;

name

ubereats

uber eats

uber-eats

uber* eats

uber *eats

uber sucks

uberg has seats

taxi

SELECT *
FROM   tbl
WHERE  LOWER(name) LIKE '%uber%'  
AND    NOT (LOWER(name) LIKE '%ubereats%' OR
            LOWER(name) LIKE '%uber%eats%');

name

uber sucks

SELECT *
FROM   tbl
WHERE  LOWER(name) LIKE '%uber%'  
AND    LOWER(name) NOT LIKE '%ubereats%'
AND    LOWER(name) NOT LIKE '%uber%eats%';

name

uber sucks

-- 2nd pattern covers both
SELECT *
FROM   tbl
WHERE  LOWER(name) LIKE '%uber%'  
AND    LOWER(name) NOT LIKE '%uber%eats%';

name

uber sucks

SELECT *
FROM   tbl
WHERE  name ~* 'uber'  
AND    name !~* 'uber.*eats';

name

uber sucks