?
Solved

Seaching in SQL

Posted on 2009-05-08
3
Medium Priority
?
268 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 750 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 750 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

777 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