MySQL Search Results Based on Tags

by Greg M Sabol   Last Updated June 16, 2018 18:10 PM

I am attempting to mine data based on:

  1. Specific event(s).
  2. Specific tag(s).

I.e. Show me these specific events with this / these specific tag(s).

Here is / are my event(s):

SELECT DATE_FORMAT(start_date, '%M %d, %Y') , title FROM #__dpcalendar_events WHERE catid = '54' AND start_date = '2018-07-05 00:00:00'

Here is my tag:

SELECT * FROM #__tags WHERE title = 'SOME TAG TITLE'

I am lost in the many to many relationship of the Joomla tags and in my own lack of knowledge. Specifically using join statements and pulling the two together.

My desired result is simply an event date and title from #__dpcalendar_events that contains 'SOME TAG TITLE' from #__tags.

Anybody care to help out a noob?

Tags : mysql tags


Related Questions



Assign cloud tags results page layout

Updated March 17, 2017 16:10 PM



RSS Feed for TAGS with invalid content URLS

Updated December 18, 2017 12:10 PM