Page 1 of 1

search engine

Posted: Wed Sep 21, 2005 2:32 am
by sebs
I am tryng to make a search engine,could you help me out with the search.My database does not have more than 200 entries.
The table is formed from :
ID,Name,VIA,CAP,Regione,Comune.
I only need the search.the fields I have read from mssql.
I need a search after all of this six entered from 6 textfields.Does anybody have something to help me?Please.

Posted: Wed Sep 21, 2005 9:27 am
by Jenk
You can use the LIKE clause in SQL, but that can be VERY slow.

Large websites make use of the metaphone algorithm which uses what a word or phrase sounds like phonetically instead of how it is spelt. (This is good for typo's)