Please Resolve this Issue

Question

1.67/5 (2 votes)

See more:

37 Futuresoft Baterry,HDD, Active 5/2/2014 9945678958 fsoft@gmail.com Okhla Okhla phase 111
38 Future India HDD,joystick,Laptop Screen, Active 4/28/2014 9971269129 fIndia@gmail.com Noida Noida
39 Tech_M Baterry,Laptop Screen,Mouse, Active 4/29/2014 9945678955 TechM@gmail.com Noida Noida
46 dgd Baterry,HDD,joystick, Active 5/3/2014 9945678958 fIndia@gmail.com
NULL NULL NULL NULL NULL NULL NULL NULL NULL
I have a database as above. here the Products are separated by comma. I have an product name in session. how will i check whether my session value is present in the product lists or not. please help.

Posted 21-Jun-14 2:58am

Member 10578683

Add a Solution

Comments

[no name] 21-Jun-14 9:02am

Fire your DBA, after that you can write a query using LIKE to do a wildcard search for the product.

Sergey Alexandrovich Kryukov 21-Jun-14 21:57pm

Best answer so far. :-)
—SA

ZurdoDev 21-Jun-14 9:04am

Where are you stuck?

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 · 2014-06-21T03:28:00

Basically, don't.
It's a very bad design idea - you should be using separate tables: one for the rows you have (less the comma separates column), one for the comma separated items (one per row with an ID), and a third to link them together:

37	Futuresoft	Active	5/2/2014	9945678958	fsoft@gmail.com	Okhla	Okhla phase 111
38	Future India	Active	4/28/2014	9971269129	fIndia@gmail.com	Noida	Noida
39	Tech_M	Active	4/29/2014	9945678955	TechM@gmail.com	Noida	Noida
46	dgd	Active	5/3/2014	9945678958	fIndia@gmail.com	
NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL

1       Baterry
2       HDD
3       joystick
4       Laptop Screen
5       Mouse

You can then add, delete, or check vlues very simply.
SQL is not good at string manipulation, and a database design like yours gives enormous problems and wastes a lot of time and resources.