mjahkoh Posted September 15, 2011 Share Posted September 15, 2011 Am looking forward to truncating all the numeric characters upto and including the leading "/" from a row in a MYSQL select statement. Is it possible Example 90/_featuredarticles/2011/12 9780/_featuredarticles/2011/12 Results _featuredarticles/2011/12 _featuredarticles/2011/12 Regards Link to comment https://forums.phpfreaks.com/topic/247181-remove-some-characters-from-a-field-in-query/ Share on other sites More sharing options...
fenway Posted September 15, 2011 Share Posted September 15, 2011 Sure -- use SUBSTRING_INDEX(). Link to comment https://forums.phpfreaks.com/topic/247181-remove-some-characters-from-a-field-in-query/#findComment-1269605 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.