I am working on a search based or rather data retrival based project i would like to retrive same data for diffrent Keywords usibg texbox contol at front end i am currently able to retrive data using one key coloumn the command i am using is
"select * from maintable where key ='" & TextBox3.Text & "'"
Here i would like to be able to use two keys ie
If user types "pump near 44" or "petrol pump near 44" he may be able to get same data since it means the same
heena92
0
Newbie Poster
Recommended Answers
Jump to PostUse like keyword instead of equal to
"select * from maintable where key like '%" & TextBox3.Text & "%'"
All 2 Replies
Reply to this topic
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.