Running MySQL 5+, Railo CF, Windows 2008 server
I want to search a field in my table for multiple keywords, and my question is what is the best way to handle this?
Here's an example of what I'm trying to do:
SELECT * FROM residential,seo WHERE residential.MLSNum=seo.MLSNum AND publiccomments LIKE '%foreclos%' OR publiccomments LIKE '%bank owned%' OR publiccomments LIKE 'REO' ORDER BY Price DESC
Is there a better way to handle this??