* saraswathy saras > i have a problem with query.I have no idea about it,whether it > can be done > or not.i want to query out name order by alphabet,The range is > provided like > Aa - Ad. > so the result should be like this:- > > Browse Aa to Ac > > Name > ---- > A
...hm... 'A' is not in the range 'Aa' - 'Ad'. > Aa > aa > Aabenraa SELECT name FROM table WHERE name BETWEEN 'Aa' AND 'Ad'; BETWEEN is described in the manual: <URL: http://www.mysql.com/doc/C/o/Comparison_Operators.html > This can also be done using 'normal' operators: SELECT name FROM table WHERE name >= 'Aa' AND name < 'Ad'; Note that BETWEEN is including, 'Ad' will be included, but not 'Ada'. This can be solved by using something like 'Aczzz' or 'Ac~'. -- Roger --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
