At the moment I am taking RSS feeds and inserting them into the database. What I need to make sure is that the same title or similar is not inserted more than once so we dont get lots of repeated stories. The same story could be covered by all 3 feeds but with slightly different titles.
How it stands at the moment is I check to see if the exact title exists do not insert into the database. What I need to do is some kind of comparison or to compare the title with ones already in the database.
I thought of using something like;
SELECT * FROM stories WHERE title LIKE '%$title%'
.. but wouldnt that compare all items in the title, words like and, a, the etc?
Any help would be very grateful.