1 Reply Latest reply on Aug 12, 2014 6:43 AM by philmodjunk

    SQL error #1064

    RobWilkerson

      Title

      SQL error #1064

      Post

           When running this sql query:

      "SELECT `customers`.`customer_name`

      FROM customers"
            
           I get this result (as expected)
            
           However, when updating the query to this:
      "SELECT `customers`.`customer_name`
      FROM customers
      WHERE (`customers`.`customer_name` Sandy)"
                 
                I get this error:

           I can't, for the life of me, find this error. Any clues?

        • 1. Re: SQL error #1064
          philmodjunk

               I'm not fully fluent in SQL and each DB system such as MySQL uses its own "Flavor" of SQL, but that WHERE clause doesn't look like correct syntax to me. That may just mean, however that the expression uses syntax that is unfamiliar to me rather than wrong. To me, it looks wrong as it's not a boolean expression that would evaluate as True or False for each record specified in the SELECT clause.