Find Data in a database Column.

Question

2.89/5 (2 votes)

See more:

i want to retrieve that records from database in which match column contains 'single-101'.

i am storing multiple values in match column like single-101,single-102,single-103 etc. And it is also possible that it can contain only a single values like 'single-101'.

i know how to retreive when it is single value in match column :

OleDbCommand cmd = new OleDbCommand("select * from Table1 where match = 'single-101'", con);

but what if there are multiple values in the match column.. Then i know above query will not work.

Please suggest me how to do this...

I will be very thankful of yours.

Posted 30-Jul-13 9:02am

Harpreet_125

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)

Maciej Los · Answer 1 · 2013-07-30T09:09:00

Solution 1

You're using OleDB, so i guess it's an Access database...

Try this:

SQL

SELECT *
FROM Table1
WHERE match Like 'single-*'

Posted 30-Jul-13 9:09am

Maciej Los

Updated 30-Jul-13 9:14am

v2

mgoad99 · Answer 2 · 2013-07-30T09:11:00

Solution 2

Try: WHERE match like '%single-101%'
This will find all records that contain 'single-101' even if there is something before or after it.

Posted 30-Jul-13 9:11am

mgoad99

Adarsh chauhan · Answer 3 · 2013-07-30T23:19:00

HI,

you can use Like operator in your query for your purpose.

SQL

SELECT * FROM Table1
WHERE match Like '%single-%'

or

SQL

SELECT * FROM Table1
WHERE match Like '*single-*'

for more details on how to use 'Like' visit

for sql database

SQL LIKE Operator[^]

http://msdn.microsoft.com/en-us/library/ms179859.aspx[^]

when using access database

http://www.techonthenet.com/access/queries/like.php[^]

http://office.microsoft.com/en-in/access-help/like-operator-HP001032253.aspx[^]

Basmeh Awad · Answer 4 · 2013-07-30T09:12:00

Solution 3

if you want selected then also you can use this

SQL

SELECT *
FROM Table1
WHERE match in ('single-101','single-102')

Posted 30-Jul-13 9:12am

Basmeh Awad