Re: [PHP] MySql number/string comparing ideas...
I would use something like this: Select * from table where value1 500 AND value2 100 hope this helps, brad From: elias [EMAIL PROTECTED] Date: Fri, 13 Jul 2001 07:06:26 -0700 To: [EMAIL PROTECTED] Subject: [PHP] MySql number/string comparing ideas... 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! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] MySql number/string comparing ideas...
well yes, somehow my field has like: field1 -- 1.2 99.123 500x120 561x112 5.5 so as you see this 'field1' have both normal numeric values and sometimes 'YYYxYYY' values... I thought that MySql can somehow compare with another number and compare correctly x with anoter value just like it: x anyway...I just forgot about it and droped the YYYxYYY from my table and only allowed numerical input, The problem is that I'm using the same field for two type of data storage... Brad Wright [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I would use something like this: Select * from table where value1 500 AND value2 100 hope this helps, brad From: elias [EMAIL PROTECTED] Date: Fri, 13 Jul 2001 07:06:26 -0700 To: [EMAIL PROTECTED] Subject: [PHP] MySql number/string comparing ideas... 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! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] MySql number/string comparing ideas...
elias, I would have to agree with Lawrence, and recommend re-designing your database, unless there is a specific reason preventing you doing this (ie like months of your life invested in the product ; ) otherwise, only allowing numerical input is a good start tho :) brad From: elias [EMAIL PROTECTED] Date: Wed, 25 Jul 2001 10:22:32 +0200 To: [EMAIL PROTECTED] Subject: Re: [PHP] MySql number/string comparing ideas... well yes, somehow my field has like: field1 -- 1.2 99.123 500x120 561x112 5.5 so as you see this 'field1' have both normal numeric values and sometimes 'YYYxYYY' values... I thought that MySql can somehow compare with another number and compare correctly x with anoter value just like it: x anyway...I just forgot about it and droped the YYYxYYY from my table and only allowed numerical input, The problem is that I'm using the same field for two type of data storage... Brad Wright [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I would use something like this: Select * from table where value1 500 AND value2 100 hope this helps, brad From: elias [EMAIL PROTECTED] Date: Fri, 13 Jul 2001 07:06:26 -0700 To: [EMAIL PROTECTED] Subject: [PHP] MySql number/string comparing ideas... 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! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] MySql number/string comparing ideas...
Thank you Brad and Lawrence. I have agreed to only allow numerical input on this specific field. And make a new one that allows X and Y ... Thanks again. Brad Wright [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... elias, I would have to agree with Lawrence, and recommend re-designing your database, unless there is a specific reason preventing you doing this (ie like months of your life invested in the product ; ) otherwise, only allowing numerical input is a good start tho :) brad From: elias [EMAIL PROTECTED] Date: Wed, 25 Jul 2001 10:22:32 +0200 To: [EMAIL PROTECTED] Subject: Re: [PHP] MySql number/string comparing ideas... well yes, somehow my field has like: field1 -- 1.2 99.123 500x120 561x112 5.5 so as you see this 'field1' have both normal numeric values and sometimes 'YYYxYYY' values... I thought that MySql can somehow compare with another number and compare correctly x with anoter value just like it: x anyway...I just forgot about it and droped the YYYxYYY from my table and only allowed numerical input, The problem is that I'm using the same field for two type of data storage... Brad Wright [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I would use something like this: Select * from table where value1 500 AND value2 100 hope this helps, brad From: elias [EMAIL PROTECTED] Date: Fri, 13 Jul 2001 07:06:26 -0700 To: [EMAIL PROTECTED] Subject: [PHP] MySql number/string comparing ideas... 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! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
