bra Posted June 12, 2008 Report Share Posted June 12, 2008 Labdien, Vai lūdzu kāds var piedāvāt kādu alternatīvu mysql selectem lai tas darbotos uz potgresql SELECT * FROM table WHERE field SOUNDS LIKE '%search string%' paldies jums jau iepriekš Link to comment Share on other sites More sharing options...
v3rb0 Posted June 12, 2008 Report Share Posted June 12, 2008 http://www.postgresql.org/docs/8.3/static/fuzzystrmatch.html Link to comment Share on other sites More sharing options...
Aleksejs Posted June 12, 2008 Report Share Posted June 12, 2008 SOUNDS LIKE ir SOUNDEX algoritms http://www.postgresql.org/docs/8.3/interac...zystrmatch.html, tādēļ vajadzētu būt šādam: SELECT * FROM table WHERE soundex(field)=soundex( 'search string') Tikai nezinu par % zīmēm... vai tās var izmantot šajā kontekstā. Link to comment Share on other sites More sharing options...
Recommended Posts