With MySQL, I need to find all records where a column is like a term OR the term is equals a column but in another table.
from table_a TA,
where TB.number = '1447'
or TA.subject like '%1447%'
Yeah, you need to do a
JOIN among the table on a common column like
select * from table_a TA join table_b TB on TA.id = TB.id where TB.number = '1447' or TA.subject like '%1447%'