Limit Characters Pulled?

[obscend]

Basically, I want to limit the number of characters being pulled from a field... Say to like 15 characters and then continue it on with a "..." in the HTML. How would I do this from the MySQL standpoint?😕

[edcellgavin]

try this pseudocode
$limit = 15;
select field1, mid(field1, 1, $limit) from table;
or
select field1, if(length(field1) > $limit , concat(mid(field1, 1, $limit ), "..."), field1) as field1 from table;

[partypete]

I usually just use:

SELECT field1, LEFT(field2, 15) AS field2_trimmed

And then conditionally add the dots if needed using PHP:

<?php if(strlen($field2_trimmed) >= 15){ ?>...<?php } ?>

(Instead of just dots, I usually have something like ...Read More which is a link to the rest of the content)

Thanks again though to edcellgavin for showing how to add the dots right in the SQL.... Life is so much easier when you REALLY know what you're doing.

Peter