MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table t(n1 varchar(50), n2 varchar(50));
insert into t select 'alice','elizabeth';
insert into t select 'chris','john';
insert into t select 'chris','mike';
insert into t select 'elizabeth','jack';
insert into t select 'jack','elizabeth';
insert into t select 'joe','mike';
insert into t select 'john','chris';
insert into t select 'mike','joe';

Records: 1  Duplicates: 0  Warnings: 0

Records: 1  Duplicates: 0  Warnings: 0

Records: 1  Duplicates: 0  Warnings: 0

Records: 1  Duplicates: 0  Warnings: 0

Records: 1  Duplicates: 0  Warnings: 0

Records: 1  Duplicates: 0  Warnings: 0

Records: 1  Duplicates: 0  Warnings: 0

Records: 1  Duplicates: 0  Warnings: 0

select * from t
where n1 < n2;

n1
n2

alice
elizabeth

chris
john

chris
mike

elizabeth
jack

joe
mike

select * from t
where not(n1 < n2)

n1
n2

jack
elizabeth

john
chris

mike
joe