[Solved] 1 x chen hyd 2 y bang mum [closed]

by


Use UNION like:

SELECT id,name,add1 from mytable
UNION
SELECT id,name,add2 from mytable

EDIT: for better performance you can use UNION ALL instead, that will give you the same result:

SELECT id,name,add1 from mytable
 UNION ALL
SELECT   id,name,add2 from mytable

4

solved 1 x chen hyd 2 y bang mum [closed]