What are the column comparisons operators?

The = , <>, <=, <, >=, >,<<,>>, <=>, AND, OR or LIKE operators are used in column comparisons in SELECT statements.