[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: search in alphabetical order



Use LIKE in your WHERE clause of your SELECT statement. In your example:
SELECT
         *
     FROM table_name
     WHERE column_name LIKE 'A%'
     ORDER BY column_name

On 3/23/2012 8:59 AM, vijaya lakshmi wrote:
>
> hi,
>
> Please guide me on how to code to search elements from database
> in alphabetical order.
>
> If we click on A all items starting from A get displayed.
>
> -- 
> Thanks & Regards
> VijayalakshmiPrasanna
>
> [Non-text portions of this message have been removed]
>
> 


[Non-text portions of this message have been removed]


[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Soap]     [Kernel Newbies]     [Yosemite]     [Yosemite Campsites]

  Powered by Linux