Guest nikhilk Posted July 8, 2009 Report Share Posted July 8, 2009 I want to search from my columni have one column in which i have p jhone lee value if user enter jhone lee then i will be able to display this record in search list using likebut if user enter lee jhone or johne p then this record notgets searched i want to search this record what can i use insted of like Link to comment Share on other sites More sharing options...
justsomeguy Posted July 8, 2009 Report Share Posted July 8, 2009 You can use MATCH..AGAINST, or you can break the search term up into each word and search for each word individually instead of the entire thing as a single phrase. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now