Here is the SQL
SELECT
post.post_id,
post.topic_id,
topic.topic_title,
post.post_text
FROM bb_posts post
LEFT JOIN bb_topics topic
ON topic.topic_id = post.topic_id
WHERE topic_title LIKE ‘%searchterms%’ OR post_text LIKE ‘%searchterms%’;
Here is the SQL
SELECT
post.post_id,
post.topic_id,
topic.topic_title,
post.post_text
FROM bb_posts post
LEFT JOIN bb_topics topic
ON topic.topic_id = post.topic_id
WHERE topic_title LIKE ‘%searchterms%’ OR post_text LIKE ‘%searchterms%’;
