Post reply

Simple Query

  • March 14, 2006 at 3:23 am

    #116433

    Dear all ,

     

    i have records like this

    1-E02162/06

     2-E02162/06

     E-02162/06

     2-E02162/06

     

    i nead the record which is E-02162/06

     

    how can i do this

     

    from

    Killer

     

     

  • March 14, 2006 at 3:44 am

    #626447

    SELECT * FROM your_table where your_column = 'E-02162/06'

    I suppose that this is not what you asked for, but I can hardly help you unless you describe what you need - that is, WHY you need the row you mentioned. Because it begins with E? Because it begins with a letter? Because it is shorter than the rest? Because the rows are ordered and this row should be displayed as last? Or do you want to show all rows that don't match certain pattern... if so, what is the pattern?

    In addition, DLL (table definition in form of CREATE TABLE) and some sample data (INSERT INTO... VALUES) would be very helpful.

  • March 14, 2006 at 6:20 am

    #626464

    hi.

     

    this is not what i need.

    i need a query that will give me the record starting with E.

    from

    killer

  • March 14, 2006 at 6:24 am

    #626465

    select * from table

    where <field_name> like 'E%'

     

    try that

  • March 14, 2006 at 9:20 am

    #626569

     

    You Can use  Either :

     

    select * from <tablename> where left(col_name,1)='E'

    It will display to you all the records starting from 'e'

    OR

    select * from <tablename> where col_name  like 'E%'

     

    Both will provide to Same Result.

     

     

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply