Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Re: how to generate confidence / weight score for a match?

by roboticus (Canon)
on Oct 11, 2012 at 00:03 UTC ( #998346=note: print w/ replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    select count(distinct hostname) as unique_hostnames, 
           count(*) as record_count
    from my_table 
    where clean_hostname is null
    
  2. or download this
    select hostname, count(*) cnt
    from the_table 
    where clean_hostname is null
    group by hostname
    order by count(*) desc
    
  3. or download this
    update my_table set clean_hostname = hostname, confidence=100.0
    where hostname in ('first.correct.host', 'second.correct.host', <etc>)
    or hostname like '%.mybiz.com'
    or hostname like '%.joescompany.net'
    
  4. or download this
    update my_table set clean_hostname = '*GARBAGE*', confidence=100.0
    where hostname in ('first.correct.host', 'second.correct.host', <etc>)
    or hostname like '%.spamzalot.foo'
    
  5. or download this
    update my_table set clean_hostname = hostname||'houston.com', confiden
    +ce=95.0
    where hostname like '%.q9ix'
    

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://998346]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (8)
As of 2014-08-20 05:06 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (105 votes), past polls