Solved

Seaching in SQL

Posted on 2009-05-08
3
250 Views
Last Modified: 2012-05-06
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
0
Comment
Question by:mousemat24
  • 2
3 Comments
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 250 total points
ID: 24341388
>>Hope this can be done using SQL 2005<<
Definitely doable with SQL Server. But more importantly can you build it?
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 24341497


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
0
 
LVL 42

Assisted Solution

by:EugeneZ
EugeneZ earned 250 total points
ID: 24341512
one more
"English Query has been discontinued in this release. It cannot be installed or upgraded. If you upgrade a Microsoft SQL Server 2000 installation that includes English Query, English Query is not affected.
http://www.infoq.com/news/English-Query-Discontinued
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question