Member Avatar for itshibu

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
  • 109 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by Kids
Member Avatar for Kids

Why don't you try this way

select * from Table1 where subject like "test"

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.