| Author |
Topic |
|
Ashu123
Starting Member
4 Posts |
 Posted - 2012-08-23 : 16:54:55
|
I am looking for Full Text Search in MS SQL, can you please help me...?
like google
i am just using LIKE in my query but it shows specific result,
it will be better if it can search like google
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-24 : 01:02:24
|
can you illustrate with an help what type of search you want to perform?
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
 |
|
|
anuraag205
Yak Posting Veteran
58 Posts |
Posted - 2012-08-24 : 01:56:28
|
If i got you right ...
YOU ARE SEARCHING FOR SOME DATA USING SQL.
search this way:
STUDENT_NAME>>>>>STUDENT_ID
ANKITAGARWAL>>>>>1111111111
BIKSUYADAVAA>>>>>2222222222
CHECHEROMERO>>>>>3333333333
select student_name from student where
student_name like 'Á%';
(GIVES YOU THE LIST STARTING WITH A)
OUTPUT:ANKITAGARWAL
select student_name from student where
student_name like '%A';
(GIVES YOU THE LIST ENDING WITH A)
OUTPUT:BIKSUYADAVAA
select student_name from student where
student_name like'%A%'
(GIVES YOU THE LIST MIDDLE LETTERS WITH WITH "A")
OUTPUT:
STUDENT_NAME
ANKITAGARWAL
BIKSUYADAVAA
Hope this helps.even am new to sql..Please
provide sample data for better understanding
'
Thanks |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-08-24 : 03:19:29
|
I'm not sure what you mena, but maybe Full Text Search is what you are looking for?
-Chad |
|
|
|
Ashu123
Starting Member
4 Posts |
Posted - 2012-08-24 : 14:47:09
|
| Yes, i am looking for Full Text Search in MS SQL, can you please help me...? |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-08-24 : 15:08:09
|
What do you need help with? Just look up Full Text Search in BOL, or on Bing.
-Chad |
|
|
|
Ashu123
Starting Member
4 Posts |
Posted - 2012-08-24 : 15:16:03
|
| Can you give me one example of Full Text Search query (MS SQL)? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
Ashu123
Starting Member
4 Posts |
Posted - 2012-08-24 : 16:01:30
|
| Thanks |
|
|
|
loveray
Starting Member
1 Post |
Posted - 2012-08-30 : 07:04:43
|
http://www.thescriptlibrary.com/ this site is diffidently solve your problem
[url=http://budgetindiaholidays.com/]Golden Triangle Tour Package[/url]
|
|
|
|
|
Search Query