Using mysql and have a tricky bit of sql: need to find the second instance of a full stop (period) and replace with carriage return in a series of fields.
Essentially, I have blocks of text that I'm trying to break up and make easier to read.
Any guidance would be wonderful.
coopster
6:39 pm on Mar 15, 2009 (gmt 0)
A combination of POSITION and SUBSTRING should do the trick. You may have to use another POSITION as the third argument for your first POSITION's starting point.
