sniperscope Posted October 3, 2011 Share Posted October 3, 2011 Hello is there any function in mysql like substr() in php. Let's say i have a record something like ID, Name, Lastname, Birthday (100004, 'Username', 'Userlastname', '2002-10-03') and i want to search user who was born in October. Is this possible with mysql? Regards Link to comment https://forums.phpfreaks.com/topic/248317-search-in-a-row/ Share on other sites More sharing options...
trq Posted October 3, 2011 Share Posted October 3, 2011 SELECT fnd FROM tbl WHERE MONTH(Birthday) = 10 Link to comment https://forums.phpfreaks.com/topic/248317-search-in-a-row/#findComment-1275133 Share on other sites More sharing options...
sniperscope Posted October 3, 2011 Author Share Posted October 3, 2011 Super fast and excellent answer. Thank you thorpe : Link to comment https://forums.phpfreaks.com/topic/248317-search-in-a-row/#findComment-1275134 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.