Untitled

MySQL JOIN based on dynamic LIKE statement between multiple tables
SELECT
    T.ticket_number,
    F.faq_id,
    F.faq_subject
FROM
    Articles A
INNER JOIN FAQs F ON
    A.a_body LIKE CONCAT('%', F.faq_id, '%')
INNER JOIN Tickets T ON
    T.ticket_id = A.ticket_id

SELECT DISTINCT t.ticket_number, f.faq_id, f.faq_subject
FROM faq.f
INNER JOIN article a ON (a.a_body RLIKE CONCAT('faq_id: ',faq_id))
INNER JOIN ticket t ON (t.ticket_id = a.ticket_id)
WHERE somecriteria