[table=“width: 500”]
[tr]
[td]id[/td]
[td]uid[/td]
[td]text[/td]
[td]date[/td]
[/tr]
[tr]
[td]1[/td]
[td]1[/td]
[td]test 1 str[/td]
[td]time[/td]
[/tr]
[tr]
[td]2[/td]
[td]1[/td]
[td]text2[/td]
[td]time[/td]
[/tr]
[tr]
[td]3[/td]
[td]10[/td]
[td]text3[/td]
[td]time[/td]
[/tr]
[tr]
[td]4[/td]
[td]8[/td]
[td]text4[/td]
[td]time[/td]
[/tr]
[tr]
[td]5[/td]
[td]13[/td]
[td]text 5 str[/td]
[td]time[/td]
[/tr]
[tr]
[td]6[/td]
[td]23[/td]
[td]text6[/td]
[td][/td]
[/tr]
[tr]
[td]7[/td]
[td]23[/td]
[td]text7 str[/td]
[td][/td]
[/tr]
[/table]
[table=“width: 500”]
[tr]
[td]id[/td]
[td]comment_id [/td]
[td]comment_parent_id[/td]
[/tr]
[tr]
[td]1[/td]
[td]2[/td]
[td]1[/td]
[/tr]
[tr]
[td]2[/td]
[td]3[/td]
[td]1[/td]
[/tr]
[tr]
[td]3[/td]
[td]5[/td]
[td]4[/td]
[/tr]
[tr]
[td]4[/td]
[td]6[/td]
[td]4[/td]
[/tr]
[tr]
[td]5[/td]
[td]11[/td]
[td]4[/td]
[/tr]
[/table]
i want to retrieve the COMMENTS ONLY that have ‘str’ in text column or any one of replies that have ‘str’ string
result here should be
[table=“width: 500”]
[tr]
[td]id[/td]
[td]uid[/td]
[td]text[/td]
[td]date[/td]
[/tr]
[tr]
[td]1[/td]
[td]1[/td]
[td]test 1 str[/td]
[td]time[/td]
[/tr]
[tr]
[td]4[/td]
[td]8[/td]
[td]text4[/td]
[td]time[/td]
[/tr]
[tr]
[td]7[/td]
[td]23[/td]
[td]text7 str[/td]
[td][/td]
[/tr]
[/table]
(here we return this comment id = 4 because one of the his replies has ‘str’)
thank you