MySQL returning incorrect results by INT Column

Question

When running the following query:

SELECT id,name,verified FROM servers WHERE verified=1 AND enabled=1 AND suspended=0 AND name LIKE '%.net%' || ip LIKE '%.net%' ORDER BY score DESC

MySQL is returning incorrect results. Here is the result of that input:

+----+-------------------+----------+
| ID |       name        | verified |
+----+-------------------+----------+
| 34 | BlockedUp         |        1 |
|  8 | aliacraft         |        1 |
| 27 | Limitless MC      |        1 |
| 31 | OPCraft           |        1 |
| 33 | LoneWolves Prison |        1 |
| 47 | purpleprison.net  |        0 |
+----+-------------------+----------+

What could be the reason for this? The last row does obviously not match the requirement of verified=1.

@james The OR '%.net%' is independent of the other conditions unless you have them wrapped in ()'s you're query says (enabled=1 and suspended = 0 and name like.net) or (ip like '%.net%') What's the IP of ID 47? I'm guessing it has .net in it. — xQbert
– xQbert, Commented Apr 17, 2015 at 19:10
Thanks everyone, I've solved the problem now with Abhik's answer. — James
– James, Commented Apr 17, 2015 at 20:21

Abhik Chakraborty · Accepted Answer · 2015-04-17 19:08:02Z

4

You need to move

AND name LIKE '%.net%' || ip LIKE '%.net%'

in braces as

AND ( name LIKE '%.net%' or ip LIKE '%.net%' )

answered Apr 17, 2015 at 19:08

Abhik Chakraborty

44.9k6 gold badges56 silver badges63 bronze badges

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

Collectives™ on Stack Overflow

MySQL returning incorrect results by INT Column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related