karthik80c
asked on
How to change Search query that contain particular word n Sql
Hi Experts ,
We need to search in database with the record contains particular Data in it e.g. name column could search for all words that contains 'jon' in it. Is this correct query
my code
We need to search in database with the record contains particular Data in it e.g. name column could search for all words that contains 'jon' in it. Is this correct query
my code
SELECT Name FROM Person WHERE Name LIKE '%Jon%'
ASKER
Hi Lokesh ,
What if i need to go for exact match
What if i need to go for exact match
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank You Experts For Your Great Effort
yes it is correct.
It will look for the word where it contains "Jon" in the Name column.