Hmm. Interesting- I don't think I ever saw that kind of statement before. A quick check in MySQL's manual, it's not used in same sense you just described;
SELECT 1 FROM foo; =
Code:
foo
1 'Literal value; returns same value for every row
Nonetheless, glad I learned something new.