mousemat24
asked on
Seaching in SQL
Hi there
Wonder if you can help me?
Im trying to copy googles searching, so on a website, I have a input box, if a user enters
after: 2009/04/06
after: 2009/04/06 tony
after: 2009/04/01 tony before: 2009/04/8
before: 2009/04/8 after: 2008/04/01
tony after: 2009/04/01 before: 2009/04/8
after:2009/04/01 before: 2009/04/8 tony
NT Temp after: 2008/04/01 before: 2009/04/8
before:2009/04/8
All of the above are all valid searches, so in the examples above if I enter >> after: 2009/04/01
it will display all records where the DATEB is after 2009/04/01
If I enter >> before:2009/04/8
it will display all records where the DATEB is before 2009/04/8
If I enter >> NT Temp after: 2008/04/01 before: 2009/04/8
it will display all records where the DATEB is after 2008/04/01 and DATEB is before: 2009/04/8 AND TITLE = NT Temp
I hope you get the overal picture?
Hope this can be done using SQL 2005
Thanks
Mousemat24
Wonder if you can help me?
Im trying to copy googles searching, so on a website, I have a input box, if a user enters
after: 2009/04/06
after: 2009/04/06 tony
after: 2009/04/01 tony before: 2009/04/8
before: 2009/04/8 after: 2008/04/01
tony after: 2009/04/01 before: 2009/04/8
after:2009/04/01 before: 2009/04/8 tony
NT Temp after: 2008/04/01 before: 2009/04/8
before:2009/04/8
All of the above are all valid searches, so in the examples above if I enter >> after: 2009/04/01
it will display all records where the DATEB is after 2009/04/01
If I enter >> before:2009/04/8
it will display all records where the DATEB is before 2009/04/8
If I enter >> NT Temp after: 2008/04/01 before: 2009/04/8
it will display all records where the DATEB is after 2008/04/01 and DATEB is before: 2009/04/8 AND TITLE = NT Temp
I hope you get the overal picture?
Hope this can be done using SQL 2005
Thanks
Mousemat24
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
about "google like search"
A Google-like Full Text Search
http://www.sqlservercentral.com/articles/Full-Text+Search+(2008)/64248/
and check
English Query Overview
http://msdn.microsoft.com/en-us/library/aa198281(SQL.80).aspx
Enabling Full-Text Search for an English Query Model
http://msdn.microsoft.com/en-us/library/aa176353(SQL.80).aspx