i have a tweet table that stores tweets and its replies like this
tweet(id, parent_id, tweet_message, time)
where parent_id is a self id if its a tweet and is of parent id if its a reply. how to do a find to pull out tweets where id = parent_id
example:
tweet(1, 1, 'My name is Harsha', 'time') parent_id = id since its a tweet and not a reply tweet(2, 1, 'Hello Harsha', 'time') parent_id = 1 which tells its a reply to the tweet with id = 1