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 Quote 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 Quote 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 : Quote Link to comment https://forums.phpfreaks.com/topic/248317-search-in-a-row/#findComment-1275134 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.