On 18.12.2005 11:06 (+0100), Andy Pieters wrote:
> Is there any operator for mysql that behaves like "LIKE" but can act on
> numbers.
>
> Let's say I wanted to select all rows where column x has a value of ~ y
>
> How should I do this?
You can use
BETWEEN x AND y
or maybe also
IN (x, x+1, ..., y)
--
Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]>
"Does the movement of the trees make the wind blow?"
http://newsboard.unclassified.de - Unclassified NewsBoard Forum
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
