Keysle
28 Dec 2011, 03:44 PM
Here is what my table looks like
postID|Message
1| I can't wait to get STARTED!!!!
2| @1 dude, you're way to hyped
3| Everyone ignore this guy --> @2
4| @3 Why ignore me?
is it possible to do a query where I can fetch all comments chained to post #4?
Conceptually:
if I ask for things chained to #4 the mysql will see "@3" (with the symbol '@') and include that in the results, but it will also look at post #3 and include post 2 because of the "@2" included... and all the way down to 1.
Is it possible to do this with 1 mySql query?
I can specify the targeted posts in a different field if I need to ( It's possible to have multiple post references though)
SEOT: 7gNI4bk8OeuPJmaWpb2u
postID|Message
1| I can't wait to get STARTED!!!!
2| @1 dude, you're way to hyped
3| Everyone ignore this guy --> @2
4| @3 Why ignore me?
is it possible to do a query where I can fetch all comments chained to post #4?
Conceptually:
if I ask for things chained to #4 the mysql will see "@3" (with the symbol '@') and include that in the results, but it will also look at post #3 and include post 2 because of the "@2" included... and all the way down to 1.
Is it possible to do this with 1 mySql query?
I can specify the targeted posts in a different field if I need to ( It's possible to have multiple post references though)
SEOT: 7gNI4bk8OeuPJmaWpb2u