Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- Can someone help me understand this please?


LifeinAsia - 5:09 pm on Jan 14, 2013 (gmt 0)


I didn't know that you could use alphanumeric characters in BETWEEN

Just remember that it's doing a character by character comparison. (So 'AB1234' is actually LESS than 'AB125' even though 125 is less than 1234.)

And I assume you already have an index on productID?


Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4534602.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com