How to write this meaning in a MySQL query?
where ((location/'$location'<2) and (location/'$location'>=1))
views:
78answers:
3
A:
where location/'$location' between 1 and 2
Edit: Since it should only match those that are precisely 2, then this should work:
where location div '$location' = 2
Tor Valamo
2009-12-12 16:36:31
The range is [1,2) location and $location are integers.
Steven
2009-12-12 16:47:21
So basically range is 2. Period. Ergo "where location/'$location' == 2" ?
Tor Valamo
2009-12-12 17:03:26
You can edit your answer to add content - the edit link is to the right of the voting, between link and flag.
OMG Ponies
2009-12-12 17:13:29
fwiw, `==` is not an operator in SQL.
Bill Karwin
2009-12-12 20:07:42
haha.. sorry... edited :p
Tor Valamo
2009-12-12 20:27:41
A:
If you want floating-point division, that should be fine, but if you want integer division:
WHERE location DIV '$location' IN (1, 2)
jboxer
2009-12-12 16:43:49
A:
I would have to know a bit more about your database but are you trying to select something such as:
select location from -- some table
where ((location/'$location'<2) and (location/'$location'>=0))
tuckster
2009-12-12 16:45:39