CrazyEngineers
CrazyEngineers

  • Data slection based on multiple conditions

    hbk

    Member

    Updated: Oct 26, 2024
    Views: 1.2K
    hi frnds.

    this is something which may seem foolish to ask, but i have been beating my head against the wall at the frustration of not being able to get over this...

    anyways, what i want to do is to select some data from a single MySQl table, using a WHERE clause on multiple columns

    eg. SELECT * from TABLENAME where COLUMN1 = VALUE1, COLUMN2 = VALUE2, COLUMN3 = VALUE3 ....

    I have tried using (),AND as well as comma between the different conditions, but they all give an error.

    please help...

    cheers...
    0
    Replies
Howdy guest!
Dear guest, you must be logged-in to participate on CrazyEngineers. We would love to have you as a member of our community. Consider creating an account or login.
Replies

  • yudi

    Member • Jul 28, 2008

    Re: data slection basd on multiple conditions

    try using OR operator coz as per my knowledge
    different conditions in where clause are seperated by OR operator......
    Are you sure? This action cannot be undone.
    Cancel

  • esakiraja

    Member • Jul 28, 2008

    Think this below eg will help u...

    Eg: select * from tablename where primarykey(column) = 'value'
    and column2 = 'value'
    and column3 = 'value'
    Are you sure? This action cannot be undone.
    Cancel

  • Itanium

    Member • Aug 1, 2008

    select * from table
    where col1 = 'value1' and
    col2 = 'value2' and
    col3 = 'value3';

    this should be the query if all the columns are holding string data.
    If any column is holding numeric data, then you dont need to specify the value within quotes.

    Can you post your exact code for us to analyse ?
    Are you sure? This action cannot be undone.
    Cancel
Home Channels Search Login Register