I have table with varchar column. Some rows are empty, some have content. While preparing SELECT statement, I accidentaly run query like that:
SELECT column_x FROM table_x WHERE column_x;
It gave me all rows where column_x content begins with numbers. How WHERE condition works in this case and why it selects that values but not values which begins with letters or special signs?