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..
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
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%)
but how to include columnname..
anyhelp.....
thanks
regards
vijay.s