0

Dear Friends,

I would like to know how to find exact word from a text data available in SQL String.

I mean,

Suppose I have a string available in Table1; ie , "My latest activities"

I want to search the word like test.

Currently I am using query

select * from Table1 where subject like "%test%"

That time it is showing the subject like above because of 'latest'. But I want the rows that exactly contains the word test.


Kindly help me....

2
Contributors
1
Reply
2
Views
9 Years
Discussion Span
Last Post by Kids
0

Why don't you try this way

select * from Table1 where subject like "test"

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.