Hello, I have a query where I am attempting to find records where a certain string appears in a given text field. For some reason, the below query returns multiple results when only a single record should be returned, and as part of the result set, it lists the same comment for every program. for some reason my
WHERE programComments.comment LIKE '%earth%'
filter is not working.
SELECT programs.*, programComments.* FROM programs INNER JOIN programComments ON programComments.commentBy = programs.programManager WHERE programComments.comment LIKE '%earth%'
Any help is appreciated