Select syntext for database search

Expand Post »

Select syntext for database search

i have a database and a table one colums with items name
des items
1 pen,pencile
2 rubber,scale

all are in one column with seperated with coma when search from only pen how it is possible to show me row for 1 whole row

like search pen ok .... show me 1 pen,penciles

Similar Threads

please correct this code in Visual Basic 4 / 5 / 6
How to delete selected row from datagridview physically from the database? in C#
access database search and display in Visual Basic 4 / 5 / 6
Database search to display correct results in PHP
Help with a asp.NET search query in ASP.NET

sem123

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Jul 2010

Permalink

Aug 2nd, 2010

Re: Select syntext for database search

Assuming the name of the table is Office AND that the name of the column is stationary, try:
SELECT * FROM Office WHERE stationary LIKE '%pen%'

hielo

Reputation Points: 116

Solved Threads: 243

Veteran Poster

Offline

1,123 posts
since Dec 2007

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP Forum Timeline: file upload

Next Thread in ASP Forum Timeline: recordset where value equals loop through array value

DaniWeb Message

Cancel Changes

User Name
Password