MySql number/string comparing ideas...
| From: | elias | Date: | Fri, 13 Jul 2001 14:06:26 +0000 |
| Subject: | MySql number/string comparing ideas... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-57725@lists.php.net to get a copy of this message | ||
Hi!
How is it possible to do a MySql query for something like:
SELECT value from table WHERE value < '500x100'
should return all values that part1 must be less than 500 and part2 less
than 100? like 499x99 and reject something like: 500x101
please give me suggestions!