Match exact keyword (Find "test", but not "testing

The Forum has been Updated

The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.

Match exact keyword (Find "test", but not "testing - Posted 18 Oct 2007 12:31 (1051 Views)

Etymon

Advanced Member

Posts: 2396

2396

I need to mod search.asp to search for exact keywords. Does anyone know how to do this?
Match exact keyword (Find "test", but not "testing")

Thanks,

Etymon
<

Posted 18 Oct 2007 12:56

HuwR

Forum Admin

Posts: 20611

20611

you will need to rewrite the query somewhat so that it used CONTAINS rather than LIKE but that would also require that you enable Full-text searching on your database<

Posted 18 Oct 2007 12:59

Etymon

Advanced Member

Posts: 2396

2396

Originally posted by HuwR
you will need to rewrite the query somewhat so that it used CONTAINS rather than LIKE but that would also require that you enable Full-text searching on your database

Thanks Huw for the terminology! That helps a lot.