Syntax error in select statement in sql

Question

In comand:

SELECT * FROM "Messages" author = 'spikinas' )

I got:

near "=": syntax error:

How should i change comand line for it to work?

jdu · Accepted Answer · 2015-04-10 16:49:43Z

2

SELECT * FROM "Messages" WHERE author = 'spikinas'

answered Apr 10, 2015 at 16:49

jdu

5712 silver badges3 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Buffalo · Accepted Answer · 2015-04-10 16:58:23Z

0

SELECT *
FROM "Name Of Your Table Without the Quotes"
WHERE author = 'spikinas'

Make sure 'spikinas' starts with LOWER CASE s, if not change the sql to 'Spikinas' UPPER CASE S

answered Apr 10, 2015 at 16:58

Buffalo

235 bronze badges

what on earth has the case of the literal go to do with it? You have absolutely no idea what collation the OP is using