Date: 04/06/07 (MySQL Communtiy) Keywords: mysql, sql i need to merge rows in a table where column1 = column1 or column2 = column2 or column1 = column2. i'd like to review the data before i merge it. i'm having trouble constructing a query that returns what i need to see. if the table looked like this: id name phone_number alt_numberi'd need a query that returns rows 1,2,3,5 and 6. we're running mysql 4.
|