CODEWITHSUNDEEP
sql
Vika Karmazaite
Vika Karmazaite

Reputation: 11

Syntax error in select statement in sql

In comand:

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

I got:

near "=": syntax error:

How should i change comand line for it to work?

Upvotes: 0

Views: 43

Answers (2)

Buffalo
Buffalo

Reputation: 23

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

Upvotes: 0

jdu
jdu

Reputation: 571

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

Upvotes: 2

Related Questions