CODEWITHSUNDEEP
mysqlsqlsyntax-error
felixvir
felixvir

Reputation: 11

SQL Query Error: Unclosed Quote

I am trying to run a sql command:

SELECT *FROM wp_options WHERE option_name = 'active_plugins';

However I only get an error that there is an unclosed quote @ 45. I am not sure what is happening as there doesn't seem to be any confusing extra quotes. Is my syntax wrong? I am using mysql 5.1.

Upvotes: 0

Views: 1106

Answers (2)

Siddarth
Siddarth

Reputation: 1020

try this variation:

Select * from wp_options where option_name = "active_plugins";

Upvotes: 1

STLDev
STLDev

Reputation: 6174

You need a space between the asterisk (*) and the word "FROM".

Upvotes: 1

Related Questions