Guest nikhilk Posted July 8, 2009 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 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
Archived
This topic is now archived and is closed to further replies.