I have two mysql query result, both result having same colum based on some conditions.
I have to check the value in the first result column is present in the second result column. If it is there i have to create new column value as 1, else it is 0. How can i do this