Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re: DBI, quoting, and LIKE searches

by Three (Pilgrim)
on Dec 27, 2002 at 14:18 UTC ( [id://222538]=note: print w/replies, xml ) Need Help??


in reply to DBI, quoting, and LIKE searches

This is sort of off topic but I think it should be said.

Like is good for searches, but I prefer to use soundex for searches..
The great thing about soundex is that it gets words that sound alike not just spelled alike.

This works really good in Oracle 9i where you can index soundex for speed.

Here is a example.

select * from demographics where soundex(name) = soundex(?)

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others goofing around in the Monastery: (1)
As of 2024-04-25 03:40 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found