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 Quote Link to comment Share on other sites More sharing options...
fenway Posted September 15, 2011 Share Posted September 15, 2011 Sure -- use SUBSTRING_INDEX(). Quote Link to comment 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.