Query won't run using mysql between clause

Query won't run using mysql between clause

El Forum
Unregistered

10-08-2010, 07:34 PM

[eluser]techgnome[/eluser]
I think what he means is that you may pick up more than you intend...
If I select records between % and % .... I could get everything from 12 to 20... and 112 and 120 and 121 and 99920000030 ... see the problem? Personally I'm a little surprised that using wildcards in a between like that doesn't throw an error.

-tg

Messages In This Thread

Query won't run using mysql between clause - by El Forum - 10-06-2010, 10:58 PM

Query won't run using mysql between clause - by El Forum - 10-07-2010, 12:36 AM

Query won't run using mysql between clause - by El Forum - 10-07-2010, 04:10 AM

Query won't run using mysql between clause - by El Forum - 10-07-2010, 06:24 AM

Query won't run using mysql between clause - by El Forum - 10-08-2010, 07:10 PM

Query won't run using mysql between clause - by El Forum - 10-08-2010, 07:34 PM