MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table Test(
col1 integer,
col2 integer
);
create table Test1(
colA integer,
colB varchar(45)
);
insert into Test values
(1, 2),
(3, 4),
(1, 5),
(1, 2),
(0, 4),
(0, 2);
insert into Test1 values
(2, 'a'),
(4, 'b');
SELECT *
FROM Test 
WHERE  col2/col1>0 AND col1<>0;


col1
col2


1
2

3
4

1
5

1
2


SHOW WARNINGS;


Level
Code
Message


Warning
1365
Division by 0

Warning
1365
Division by 0


SELECT *
FROM Test T JOIN Test1 T1 ON T.col2=T1.colA
WHERE  T.col2/T.col1>0 AND T.col1<>0;


col1
col2
colA
colB


1
2
2
a

3
4
4
b

1
2
2
a


SHOW WARNINGS;
EXPLAIN ANALYZE SELECT *
FROM Test T JOIN Test1 T1 ON T.col2=T1.colA
WHERE  T.col2/T.col1>0 AND T.col1<>0;


EXPLAIN


-> Filter: ((T1.colA / T.col1) > 0)  (cost=1.00 rows=0) (actual time=0.047..0.061 rows=3 loops=1)
    -> Inner hash join (T.col2 = T1.colA)  (cost=1.00 rows=0) (actual time=0.039..0.051 rows=3 loops=1)
        -> Filter: (T.col1 <> 0)  (cost=0.23 rows=1) (actual time=0.006..0.015 rows=4 loops=1)
            -> Table scan on T  (cost=0.23 rows=6) (actual time=0.004..0.012 rows=6 loops=1)
        -> Hash
            -> Table scan on T1  (cost=0.45 rows=2) (actual time=0.015..0.019 rows=2 loops=1)