MySQL SELECT with fields less and greater than values

Question

I am trying to do a select query on MySQL with phpMyAdmin or PHP with PDO.

SELECT 'uid' FROM 'clusters' WHERE 'lat'<='47.21125' AND 'lat'>='39.21125' AND 'lng'<='32.90243' AND 'lng'>='22.90243'

However, phpMyAdmin says:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''clusters' WHERE 'lat'<='47.21125' AND 'lat'>='39.21125' AND 'lng'<='32.90243' A' at line 1

What is wrong with it?

Duplicate of stackoverflow.com/questions/11321491/…

Your Common Sense
– Your Common Sense

2013-04-07 17:04:32 +00:00
Commented Apr 7, 2013 at 17:04 — Your Common Sense
– Your Common Sense, Commented Apr 7, 2013 at 17:04

Explosion Pills · Accepted Answer · 2013-04-07 17:09:51Z

10

'' creates a string literal in MySQL, so your query is selecting the literal "uid" from the literal "clusters," which is invalid. Use backtics (or nothing)

SELECT Uid FROM clusters WHERE lat <= 47.21125 AND lat >= 39.21125
AND lng >= 22.90243

edited Apr 7, 2013 at 17:09

answered Apr 7, 2013 at 17:03

Explosion Pills

192k56 gold badges341 silver badges417 bronze badges

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

5 Comments

ajreal Over a year ago

i just want to say, is not me who give a down vote. however, you should not using quote for the double value as well.

Explosion Pills Over a year ago

@ajreal I don't think that it makes a difference, but I edited my answer to remove them

ajreal Over a year ago

the quote will force mysql to perform unnecessary casting, which by no mean ... the index could be ignored (however, the SQL by OP is not using index)

Explosion Pills Over a year ago

@ajreal that's only if it's a decimal and not a string. It's possible that the column is a string, but I think it is more likely that it is a decimal so I changed my answer anyway. Can you cite the fact that MySQL ignores indices on numeric columns when compared to a string value?

ajreal Over a year ago

bugs.mysql.com/bug.php?id=34384 , bugs.mysql.com/bug.php?id=43319 .. for both bug, the example are using really BIG numeric number, however, I believe, the core issue is caused by using the "quote" as it mentioned in the details.

Collectives™ on Stack Overflow

MySQL SELECT with fields less and greater than values

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related