How to create a search start or ending or between any data match after space & before after first word or ending whatever search should be work.

Question

0.00/5 (No votes)

See more:

how to create a search first type first word then type middle word then type last word of row then again type second word of row?

like

BUTTON PLASTIC 10MM FILTER 2HOLE

I want search Button plastic Hole search exactly do work.
but i want search like (Button Hole plastic) or (button 10mm 2hole) or (2hole button 10mm) not work search or Button Filter 10MM

Simply I want to search start or ending or between any data match after space & before after first word or ending whatever search should be work.

Please Help if you know

What I have tried:

I am using Wild card in SQL for searching and implementing c#.

Posted 29-Apr-16 0:18am

Member 11151453

Updated 29-Apr-16 0:51am

Add a Solution

Comments

Nigam,Ashish 29-Apr-16 6:50am

can you mention your query here.

Karthik_Mahalingam 29-Apr-16 8:58am

do as the same in old solution for similar question
http://www.codeproject.com/Answers/1096421/How-do-I-create-a-search-after-spacing-first-word#answer1

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2016-04-29T00:51:00

Solution 1

Basically, you need to produce a separate WHERE conditionfor each word you want:

SQL

... WHERE myColumn LIKE '%Button% OR myColumn LIKE '%10MM%' OR ...

Will find all rows which contain any of the words.
The other solution would be to use a full text search, but they are more complex to set up and use: Full-Text Search[^]

Posted 29-Apr-16 0:51am

OriginalGriff

Comments

Member 11151453 29-Apr-16 7:43am

Exactly but do in c#

OriginalGriff 29-Apr-16 8:26am

It's pretty much the same problem in C# - if you have it in C# collections, then have a look here:
http://stackoverflow.com/questions/3519539/how-to-check-if-a-string-contains-any-of-some-strings
Basically, there is no short cut!