sql - MySql - get the opposite of the column from my answer -
this question has answer here: mysql “not in” query 5 answers i have database 3 columns: id , numbers1 , numbers2 . i doing query this: select id numbers numbers.numbers1 = numbers.numbers2; and getting result of in id column. assuming have 1,2,3,4,5 in id column , getting result 1,2,3 how show have left column? mean how show in result 4,5? , not 1,2,3 got in result? the simplest query opposite - instead of = , using != : select id numbers numbers.numbers1 != numbers.numbers2;