Quote Originally Posted by segfault View Post
Qt Code:
  1. SELECT 'foo' FROM myTable
  2. or
  3. SELECT foo FROM myTable
To copy to clipboard, switch view to plain text mode 

doesn't matter, since they work both.
Yes they both work, but they do different things of course.

The first will always return the text foo, no matter what is actually in the table, and the second will return the content of the column with name foo.