Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2012
    Posts
    1

    Unanswered: Issue in Retrieving Data from Database

    I have lot of data in my database i need to retrieve it using single command by using where clause so, any one please help me please.

    Now i will say how my data resides in my database

    In my table i have 6 columns in that six i have one field named as Htno

    In Htno i have hallticket numbers like this

    08MA1A1201
    08MA1A1202
    08MA1A1203
    08MA1A0501
    08MA1A0502
    08MA1A0503
    08MA1A0401
    08MA1A0402
    08MA1A0403
    so on .....
    My problem is i need to retrieve only specific data from that table like the hall ticket number starts with "08MA1A12" code only

    So, please solve my problems any one please

  2. #2
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    You need to issue a SELECT with a WHERE clause.

    Code:
    SELECT * FROM table WHERE Htno LIKE '08MA1A12%';
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •