Member Avatar for rajeesh_rsn

Hi friends ,

I had a table which contains tourist information of a country. the table structure as follows

state | place | placeid | activities
==============================================================================
state1 | palce 1 | 12457 | swimming,trekking,hillstation,waterfall |
------------------------------------------------------------------------------
state2 | palce 2 | 12458 | beach,backwater,ayurveda,fishing |
-------------------------------------------------------------------------------


Ok now I want to do a search in my home page using the activities. Means if user click on the "waterfall" button in my home page then I want to list all the places which contain "waterfall"

Please help me how to query this search
Thanks in advance
Rajeesh

  • 2 Contributors
  • 1 Reply
  • 90 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by lili.edryana
Member Avatar for lili.edryana 
SELECT place WHERE activities LIKE %waterfall%
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.