Sign = in SQL

In C/java there's difference between = and ==. First one is assignment operrator, and == is equality operator.
In SQL Select query:
select * from table_a where col1 = 'abc';
here = is used to check for equality. that's weird!