select PPC_MembersAccounts.MemberID, PPC_MembersAccounts.STATUS, PPC_MembersTerms.TermID, PPC_MembersSites.CategoryID, max(PPC_MembersBids.Bid) as MBid from PPC_MembersAccounts, PPC_MembersTerms, PPC_MembersBids, PPC_MembersSites where PPC_MembersTerms.TermID>0  and ( 'women's' like CONCAT('%',PPC_MembersTerms.Term,'%') OR  CONCAT('%',PPC_MembersTerms.Term,'%') like '%women's%') and ( 'health' like CONCAT('%',PPC_MembersTerms.Term,'%') OR  CONCAT('%',PPC_MembersTerms.Term,'%') like '%health%') and PPC_MembersAccounts.MemberID=PPC_MembersTerms.MemberID and PPC_MembersAccounts.STATUS=0 and PPC_MembersSites.MemberID=PPC_MembersTerms.MemberID and PPC_MembersBids.TermID=PPC_MembersTerms.TermID group by PPC_MembersTerms.MemberID order by MBid desc<br>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's' like CONCAT('%',PPC_MembersTerms.Term,'%') OR  CONCAT('%',PPC_MembersTerms.Te' at line 1