[thelist] MySQL extracting a teaser from a text field

[Frank]

At 05:27 PM 2005-08-22, you wrote:
>Unfortunately this has to work in MySQL 3.23, so subqueries aren't an option.

Have you considered using your favourite server side language? Simplest 
solution in my books. Alternatively, you could cut it off at X chars (even 
though that's not particularly graceful) or even every X spaces. If you 
assume that a sentence contains 10 spaces, you get the contents of and use 
a regex to make space #10 your delimiter.



Frank Marion     lists at frankmarion.com      Keep the signal high.