|
I am trying to do a comparison between company names using SOUNDEX, but the php call for soundex only outputs 3 digits so the comparisons aren't quite accurate. Is there a way to get a better soundex output so that the results are more accurate?
Started by AFG on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
To do run SOUNDEX() at the database level:
$result = $db->query(" SELECT company.id, company.name, SOUNDEX(company.name) AS soundex FROM company WHERE company.name SOUNDS LIKE '$companyName' ");.
|
|
Hi there,
Here is my problem. For example I have a table Products that contain a field Name :
Products ID | Name | .. 1 | "USB Key 10Go" 2 | "Intel computer" 3 | "12 inches laptop computer" ...
I'm currently implementing a simple search engine (SQL Server...
Started by Charles on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Otherwise, ....
Its just that the SOUNDEX be the best if it's an option.
Rather than use Soundex you might be better off computing the Levenshtein distance between the two feature in SQL Server? I know this is not exactly what you asked for.
|
|
I have a legacy DB with: firstname, lastname, address1, address2, address3, address4, zipcode The data is scattered between the different columns with no consistency eg the actual zipcode could be in any column and there are plenty of typos.
Is there ...
Started by simon831 on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Would look something like this:
select id, checksum(*) from tableName a join tableName b better results in doing this than in looking....
This will give you a 32bit hash for every record in your table:
select checksum(*), binary_checksum).
|
Ask your Facebook Friends
|
I need to write what I'd like to call a Valley Girl-query. I need to SELECT something that's LIKE IN - something like this:
SELECT * FROM Table1 WHERE Name LIKE IN ( SELECT Name FROM Table2 )
The reason for this is I've got a table full of company names...
Started by M. Nilsson on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
I think:
SELECT * FROM table1 WHERE EXISTS (SELECT Name FROM Table2 WHERE Table1.Name LIKE Name)
select * from Table1 t1 inner join Table2 t2 on (t1.name like t2.name + '%')
or without '%' sign if you want :)
Hi,
Here's one way ....
|
|
Hello all,
I'm running into a problem when trying to select records from my 2005 MS-SQL database (I'm still very new to SQL, but I learned and use the basic commands from w3schools already). In theory, all my manufacturer records should be unique. At ...
Started by Bill Sambrone on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
If you are doing some data mining, you could also try the SOUNDEX and DIFFERENCE function in SQL('Cables To Go');
and....
Yield some interesting result for you:
SELECT * FROM ItemCatalog WHERE SOUNDEX(Manufacturer) = SOUNDEX.
|
|
In SQL Server 2005, I have a Product search that looks like:
select ProductID, Name, Email from Product where Name = @Name
I've been asked to ignore a couple "special" characters in Product.Name, so that a search for "Potatoes" returns "Po-ta-toes" as...
Started by dnord on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
select ProductID, Name, Email from Product where REPLACE(Name, '-', '') = @Name, searchable_name , precalculate the results of the REPLACE (and any other tweaks, e.g., SOUNDEX) on INSERT.
To be alphabetic, like this...
|
|
I'm quite new to SQL and have a question about matching names from two columns located within a table:
Let's say I want to use the soundex() function to match two columsn. If I use this query:
SELECT * FROM tablename WHERE SOUNDEX(column1)=SOUNDEX(column...
Started by MrFancypants on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
The table to itself on that relationship as such:
SELECT * FROM tablename t1 JOIN tablename t2 ON SOUNDEXIf your table has a key, say id , you can try:
select A.column1, B.column2 from tablename as A, tablename as B where (A.id != B.id)....
|
|
I am using Oracle 10g Enterprise edition.
A table in our Oracle database stores the soundex value representation of another text column. We are using a custom soundex implementation in which the soundex values are longer than are generated by traditional...
Started by Kevin Babcock on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Set pages 0 set lines 200 drop table random....
Is the table is being searched by the partitioning key in addition to the SOUNDEX value? Or is it being searched just by the SOUNDEX column?
If you are just trying to achieve an even distribution.
|
|
I have a site that needs to search thru about 20-30k records, which are mostly movie and TV show names. The site runs php/mysql with memcache.
Im looking to replace the FULLTEXT with soundex() searching that I currently have, which works... kind of, but...
Started by Yegor on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
If you want to search for a movie title :
select * from movie'), soundex('cases'), soundex('to'), soundex('consider'))) select * from with_soundex where match(soundex....
There is a function SOUNDEX in mysql.
|
|
Everyone knows the "=" sign.
SELECT * FROM mytable WHERE column1 = column2;
However, what if I have different contents in column1 and column2...but they are VERY similar? (maybe off by a space, or have a word that's different).
Is it possible to:
SELECT...
Started by alex on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
In MySQL you have to write stored procedure....
It gives you the number value which discribes the difference between two strings .
What you are looking for is called Levenstein distance.
You retrieve all the data then process it with whatever you are using.. .
|
