List:General Discussion« Previous MessageNext Message »
From:misiaQ Date:November 4 2009 3:26pm
Subject:RE: Alphabetical search to and from
View as plain text  
Hi,

You're right on one hand. But on the another in some languages you have a
more characters after the Z letter.
Apart from that try this:

select 'F' as test
union
select 'FAA'
order by test;

and you'll see:

test
---------
F
FAA

Regards,
m.

-----Original Message-----
From: Michael Dykman [mailto:mdykman@stripped] 
Sent: 04 November 2009 15:19
To: Dave M G
Cc: mysql@stripped
Subject: Re: Alphabetical search to and from

Haven't tried this myself, but would this not work while permitting
the index to engage?

select * from country Name between 'FAAAAAAAAAA' and 'PZZZZZZZZZZ'

On Wed, Nov 4, 2009 at 10:15 AM, misiaQ <misiaq@stripped> wrote:
> Try this:
> select * from country where LEFT(Name, 1) between 'F' and 'P';
>
> Regards,
> m.
>
> -----Original Message-----
> From: Dave M G [mailto:dave@stripped]
> Sent: 04 November 2009 14:52
> To: mysql@stripped
> Subject: Alphabetical search to and from
>
> MySQL,
>
> This should be a fairly simple question.
>
> I have a table with a bunch of people's names. I want to find people
> who's name begins within a certain range of characters.
>
> All names between F and P, for example.
>
> What SELECT statement would I use to do that?
>
> Thank you for any advice.
>
> --
> Dave M G
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>
>
> ----------------------------------------------------------------------
> Konkurs: Wygrywaj nagrody z Pudzianem!
> Sprawd¼ >> http://link.interia.pl/f240e
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>



-- 
 - michael dykman
 - mdykman@stripped

"May you live every day of your life."
    Jonathan Swift

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1



Tanie rozmowy telefoniczne!
Sprawdz >> http://link.interia.pl/f2410

Thread
Alphabetical search to and fromDave M G4 Nov
  • Re: Alphabetical search to and fromJay Ess4 Nov
  • RE: Alphabetical search to and frommisiaQ4 Nov
    • Re: Alphabetical search to and fromMichael Dykman4 Nov
      • RE: Alphabetical search to and frommisiaQ4 Nov
        • Re: Alphabetical search to and fromMichael Dykman4 Nov
          • Re: Alphabetical search to and fromJay Ess4 Nov
            • RE: Alphabetical search to and frommisiaQ4 Nov
              • Re: Alphabetical search to and from [SOLVED]Dave M G5 Nov
  • Re: Alphabetical search to and fromSteve Edberg4 Nov