Simple Postgresql Statement – column name does not exists

by

I would guess:

 SELECT * FROM employee WHERE "lName" LIKE 'Smith'

(note the different quotes; "foo" is a quoted identifier; 'foo' is a string literal)

Also, in most SQL dialects, a LIKE without a wildcard is equivalent to =; did you mean to include a wildcard?

More Related Contents:

  1. Cannot simply use PostgreSQL table name (“relation does not exist”)
  2. Best way to get result count before LIMIT was applied
  3. Laravel: Error [PDOException]: Could not Find Driver in PostgreSQL
  4. Get last insert id after a prepared insert with PDO
  5. pg_query result contains strings instead of integer, numeric
  6. Enabling PostgreSQL support in PHP on Mac OS X
  7. How to pass custom type array to Postgres function
  8. Can’t decrypt using pgcrypto from AES-256-CBC but AES-128-CBC is OK
  9. How to bind SQL variables in PHP?
  10. How do I enable php to work with postgresql?
  11. Setting a connect timeout with PDO
  12. How to prevent PDO from interpreting a question mark as a placeholder?
  13. Pass array literal to PostgreSQL function
  14. Postgres now() timestamp doesn’t change, when script works
  15. mysql_insert_id alternative for postgresql
  16. Convert PostgreSQL array to PHP array
  17. Different timezone_types on DateTime object
  18. My code is not responding as i want it to be? [closed]
  19. deny direct access to a folder and file by htaccess
  20. PHP page redirect [duplicate]
  21. What is the maximum length of a String in PHP?
  22. mysql_fetch_array return only one row
  23. Get Youtube Video ID from html code with PHP
  24. Insert multiple rows with PDO prepared statements
  25. Difference between mt_rand() and rand()
  26. How to display Currency in Indian Numbering Format in PHP?
  27. MySQL Alter Table Add Field Before or After a field already present
  28. mysql error ‘TYPE=MyISAM’
  29. Will PHP script be executed after header redirect?
  30. jQuery Mobile: Sending data from one page to the another

Leave a Comment