how to use like query in sql server

Question

3.00/5 (1 vote)

See more:

Table as follows (Table Name FAQ)

Category Questions Answers

Admin do you have rights to book course? Yes

Admin at what time class starts? 2PM

Software All course photo is necessary? Yes

Design page as follows
Two Radio Button as follows

By Word (RadioButton1) By Category (RadioButton2)

Then i have one textbox(Textbox1)

Then i have one Search Button

First i select the By Word(RadioButton1) Then in the textbox i type course(from the table(FAQ)) then i click the Search Button in gridview display as follows

From the table (FAQ) want to check the word course is there?

In gridview as follows

Category Questions Answers

Admin do you have rights to book course? Yes

Software All course photo is necessary? Yes

Becuase in the table(FAQ) course word is there.

for that how can write the sql like query

matching the word course from the table FAQ.

how can i write the sql like query for my requirement.

Regards,
Narasiman P.

Posted 13-Oct-13 22:17pm

Member 8054539

Add a Solution

4 solutions

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 · 2013-10-13T22:25:00

Like is pretty simple: it'a pretty much the same as "=" but with wild cards.
In your case, the most useful wildcard is probably "%" which matches zero or more of any character, much as "*" does in windows filenames.

So if you have a table contains Titles:

The Cat sat on the mat
The Cat who looked at a king
Cats a furry
The ArtistoCat
All about Dogs

Then:

SELECT Title FROM MyTable WHERE Title LIKE '%Cat%'

would return the top four titles, but not the final one.

prashantttt · Answer 2 · 2013-10-14T01:40:00

Solution 4

select QuestionColumn from FAQ where NameofColumnWhere"course"WordIsPresent like '%course%'

Posted 14-Oct-13 1:40am

prashantttt

Updated 14-Oct-13 1:45am

v3

Comments

Ankur^\m/ 14-Oct-13 7:52am

What extra have you added to the answer which is not present in the above answers?

Khandwawala Hatim · Answer 3 · 2013-10-13T22:50:00

Solution 2

Check this out.

Posted 13-Oct-13 22:50pm

Khandwawala Hatim

Comments

Ankur^\m/ 14-Oct-13 7:49am

Adding a description to the link helps. :)

Renju Vinod · Answer 4 · 2013-10-14T00:40:00

Solution 3

Hi Narasiman P,

Please check this.

SQL

select Category, Questions, Answers from faq where Questions like '%course%'

Posted 14-Oct-13 0:40am

Renju Vinod

Comments

Ankur^\m/ 14-Oct-13 7:50am

Care explaining what does it do?

how to use like query in sql server

4 solutions

Solution 1

Solution 4

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us