MySQL database search help wanted

by terry1288

Posted: 13 years ago 4 replies

PROGRAMMING

I would like to be able to perform a search in my
MySQL database to find duplicate articles submitted
to my site.

The following code appears to work but I would like to limit
the amount of characters the search checks to save straining
the server, if possible.

SELECT COUNT(*), textArticleText FROM tblarticles
GROUP BY textArticleText
HAVING COUNT(*)>1;

Has anyone any idea how to limit the characters searched.

Any help appreciated.

Thanks

Terry

#database #mysql #search #wanted

KirkMcD 13 years ago

use substring
MySQL :: MySQL 5.0 Reference Manual :: 11.5 String Functions
- Thanks
{{ DiscussionBoard.errors[3276286].message }}
CBSnooper 13 years ago

In the select you could chop the left most, say, 20 characters off the article text string, eg

PHP Code:

SELECT COUNT(*), LEFT(textArticleText,20) as chopped FROM tblarticles GROUP BY chopped HAVING COUNT(*)>1;

I'm not sure if that would add to the server overhead though!
- Thanks
Signature

Mike
~~~~
CBSnooper - Take the hard work out of finding hot Clickbank products.
{{ DiscussionBoard.errors[3276296].message }}
best web designer 13 years ago
Hi,
The following code will be useful in detecting the dublicate articles
Code:

SELECT DISTINCT column1 from table group by column1 HAVING count(column1) > 1
- Thanks
- 1 reply
{{ DiscussionBoard.errors[3279240].message }}
- terry1288 13 years ago
  
  Thanks to all of you
  for your suggestions.
  
  Terry
  
  Thanks
  
  Signature
  Learn Affiliate Marketing TerryTill.com
  
  {{ DiscussionBoard.errors[3281437].message }}

Trending Topics

1 {{ upvoteCount | shortNum }}

Some interesting stats about brand comms

WarriorForum.com 13 minutes ago in Internet Marketing

We can't emphasize more about the importance of marketing communications. It's how we reach out to our customers, after all. 81% of consumers unsubscribe from brands that bombard them with ... [read more]

Reply
Share
1 {{ upvoteCount | shortNum }}

Fixing a massive traffic drop after rebranding

WarriorForum.com 1 hour ago in SEO

Rebranding happens for various reasons -- it could an M&A, PR problems, or perhaps investor demands that warrant a brand change. If you're launching a completely new site design with ... [read more]

Reply
Share
1 {{ upvoteCount | shortNum }}

Meta AI now has Google Search results

WarriorForum.com 1 hour ago in AI

Meta AI search results will now include Google Search. This makes it the first AI assistant to include search results from both Google and Microsoft. This is what the search ... [read more]

Reply
Share
1 {{ upvoteCount | shortNum }}

Looking at the average screen time and socmed usage

WarriorForum.com 1 hour ago in Learn

We're seeing an ever increasing usage in social media, with the average person spending three minutes more looking at their screens daily. Now this infographic takes a look at countries ... [read more]

Reply
Share
68 {{ upvoteCount | shortNum }}

What's the Best IM-Related Skill to Learn Today That Can Help in the Future?

Marx Vergel Melencio 2 days ago in Internet Marketing

I'll start. My vote goes to: The ability to design rational thought experiments. • That's the most useful skill that I learned throughout the years for future-proofing anything. I ... [read more]

25 Replies
Share

Advertise with Us