how to create a fulltext index in sql

Question

0.00/5 (No votes)

See more:

i was using one text box and one button..
i have using this table

SQL

   ISBN       keywords       author_name         title
23232323      hi            RAJKUMAR          dffd
2223234       tty               MANOJ KUMAR     dffd
33333333333333  u            RAJKUMAR           GGG
44542232233   fgf           MANOJ KUMAR        dffd

now i was search a one column for example hi or,RAJKUMAR,OR 23232323,dffd any one that was search it. how to solve this pls help me
but i was using multiple table

Posted 3-Sep-15 20:39pm

MohamedEliyas

Updated 3-Sep-15 22:24pm

Schatak

v3

Add a Solution

Comments

Suvendu Shekhar Giri 4-Sep-15 3:43am

What is your DBMS? SQL Server?

MohamedEliyas 4-Sep-15 5:07am

YES SQL SERVER

Schatak 4-Sep-15 4:27am

Your question is unclear, are you trying to search in SQL IDE or though code?
if through your code then what is the issue?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Suvendu Shekhar Giri · Accepted Answer · 2015-09-04T00:12:00

You can do it in two ways-
1. Usng full text search
Refere these links to understand full text search
Full-Text Search[^]
Understanding Full-Text Indexing in SQL Server[^]
2. Using multiple conditions in WHERE clause
You may build query like -

SQL

SELECT ISBN, keywords, author_name, title
FROM YourTable
WHERE ISBN LIKE '%'+@TextToSearch+'%' OR keywords LIKE '%'+@TextToSearch+'%' OR author_name LIKE '%'+@TextToSearch+'%' OR title LIKE '%'+@TextToSearch+'%'

I would recommend to use full text search.

Hope, it helps :)