Jump to content

Archived

This topic is now archived and is closed to further replies.

ale1981

MySQL LIKE statement

Recommended Posts

Ok, here is my problem, I need to compare RSS titles taken from 3 different feeds.

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;

[code]
SELECT * FROM stories WHERE title LIKE '%$title%'
[/code]

.. but wouldnt that compare all items in the title, words like and, a, the etc?


Any help would be very grateful.

Share this post


Link to post
Share on other sites
Well, the wildcards won't help much if $title is multi-word... in fact, any exact match is probably useless.  You'll have to come up with a scoring algorithm and rank matches to do this properly.

Share this post


Link to post
Share on other sites
Thanks for your reply, bit beyond me, do you know any sites with tutorials on this kind of thing?

Share this post


Link to post
Share on other sites
Guess so... I thought you were looking for a MySQL-only solution.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.