[SOLVED] mysql where problem

[Q695]

I'm getting a problem in this statement:

SELECT * FROM shows WHERE 'show' = '1' ORDER BY rank ASC;

 

 

my data dictionary is:

photos

Table comments: InnoDB free: 3072 kB

 

Field Type Null Default Comments

rank tinyint(4) No 2

location tinytext No

car int(11) No

shows

Table comments: InnoDB free: 3072 kB

 

Field Type Null Default Comments

rank tinyint(4) No 2

location tinytext No

show smallint(6) No

 

 

What's wrong with the query in the where section, because I don't see where it is?  There are two files that work almost exactly the same way, just two different pages.

[Mchl]

SELECT * FROM shows WHERE `show` = '1' ORDER BY rank ASC;

 

Use `` not '' around column names

[Q695]

Issue solved .

 

Thanks Mchl.

[Mchl]

Issue solved .

 

So mark the topic as such

 

Cheers

[fenway]

SELECT * FROM shows WHERE `show` = '1' ORDER BY rank ASC;

 

Use `` not '' around column names

Or, don't do either and don't use reserved keywords as column names.