retrieving same column twice from a table

Posted by GJ on Stack Overflow See other posts from Stack Overflow or by GJ
Published on 2010-02-24T08:39:56Z Indexed on 2010/04/07 17:03 UTC
Read the original article Hit count: 150

Filed under:

hello all i hav a table named address which has id, title and parent_id fields. in title column the name of regions and districts are inserted. the regions have parent_id zero and parent_id of the districts are id of the regions. i want a query which display regions in one column and its respective districts in another column. hope u guys understand what i mean.. thank u all.

© Stack Overflow or respective owner

Related posts about mysql