Member Avatar for sem123

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

  • 2 Contributors
  • 1 Reply
  • 76 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by hielo
Member Avatar for hielo

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%'

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.