how to select rows from table where one column not contain datas of another column

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • vjayis
    New Member
    • Mar 2008
    • 134

    how to select rows from table where one column not contain datas of another column

    i m having a table in which two columns had to compared for retrieving datas.,

    totalmatches, matchestoday are the columnnames in which IDs are stored as comma separated values.

    so for the present day i m displaying datas from the matchestoday column and update the totalmatches column by concatinating it with matchestoday.,

    And for the next day i need to display new datas which must not include IDs present in matchestotal column.. so i need a query to display the results..

    Code:
    "select 8 from tablename where totalmatches not like ....."(%matchestoday%)
    if its an string i can replace the coulmnname with the string to get the results..

    but how to include columnname..

    anyhelp.....
    thanks

    regards
    vijay.s
Working...