Solved

Seaching in SQL

Posted on 2009-05-08
3
264 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 43

Expert Comment

by:Eugene Z
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 43

Assisted Solution

by:Eugene Z
Eugene Z 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

689 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