Jump to content


Photo

MySQL LIKE statement


  • Please log in to reply
4 replies to this topic

#1 ale1981

ale1981
  • Members
  • PipPipPip
  • Advanced Member
  • 65 posts

Posted 14 September 2006 - 06:28 PM

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;

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.


#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 14 September 2006 - 07:00 PM

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.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 ale1981

ale1981
  • Members
  • PipPipPip
  • Advanced Member
  • 65 posts

Posted 15 September 2006 - 08:25 AM

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

#4 ale1981

ale1981
  • Members
  • PipPipPip
  • Advanced Member
  • 65 posts

Posted 15 September 2006 - 10:41 AM

Seems like php's similar_text function works well for what I needed.

#5 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 15 September 2006 - 12:47 PM

Guess so... I thought you were looking for a MySQL-only solution.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users