Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

Comparing inputs before inserting into MySQL for "sounds-like" similarity

by hacker (Priest)
on Apr 27, 2008 at 14:18 UTC ( [id://683137]=perlquestion: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    my $users_sth = $dbh->prepare(qq{
            INSERT IGNORE INTO `wp_users` 
    ...
                    $post_sth->execute($post_author, $now, @output, $title
    +s[$i]);
            }
    };
    
  2. or download this
    ALTER TABLE `wp_posts` ADD UNIQUE (`post_title`);
    
  3. or download this
    |  597 |  102 | New Home Builders in Houston                          
    +                                                                     
    +   
    |  595 |  102 | New Home Builders In Houston Texas                    
    +                                                                     
    +  
    ...
    
    |  772 |  136 | Buy to Let Rental Properties                          
    +                                                                     
    + 
    |  754 |  136 | Buy to Let Rental Property
    

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://683137]
Approved by stiller
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (5)
As of 2024-04-16 07:25 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found