garry27 Posted October 31, 2008 Share Posted October 31, 2008 I'm trying to get a result set for all records with date set to the current month by using a LIKE clause. Unfortunately, it returns a 0 result set. Without the LIKE clause the code works as expected. "SELECT GA_Gig.gigID, GA_Gig.date, GA_User.stageName, GA_Venue.venue, GA_Town.town, GA_Gig.startTime, GA_Gig.endTime, GA_Gig.musicType, GA_Gig.entryFee, GA_Gig.gigNote FROM GA_Gig, GA_Town, GA_Venue, GA_User WHERE GA_Gig.date LIKE '2008-10-%' AND GA_Gig.townID = GA_Town.townID AND GA_Gig.venueID = GA_Venue.venueID AND GA_Gig.userEmail = GA_User.userEmail AND GA_Town.region = 'North East' ORDER BY date " Any advice please? Link to comment https://forums.phpfreaks.com/topic/130912-problem-with-query-using-like/ Share on other sites More sharing options...
Barand Posted October 31, 2008 Share Posted October 31, 2008 try WHERE DATE_FORMAT(GA_Gig.date, '%Y-%m') = '2008-10' Link to comment https://forums.phpfreaks.com/topic/130912-problem-with-query-using-like/#findComment-679586 Share on other sites More sharing options...
fenway Posted November 3, 2008 Share Posted November 3, 2008 Or EXTRACT(YEAR_MONTH FROM GA_Gig.date) = '200810' Link to comment https://forums.phpfreaks.com/topic/130912-problem-with-query-using-like/#findComment-681414 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.