[RESOLVED] Mysql data-dump question

exponder

I tired searching for my question, but it's kinda hard to search on.

How can I return only a few bytes of text from a mysql query? Is there a query setting like LIMI 0,10 on results, or do I need to combine some php fuctions?

Not looking for a script, just a point in the right direction.

Thanks a head of time for any suggestions!

Cheers,
Derrick

exponder

Doh! good ol' substr_replace. Haha.

<?php

function truncate ($string, $max = 50, $rep = '') {
   $leave = $max - strlen ($rep);
   return substr_replace($string, $rep, $leave);
} 

echo truncate ('akfhslakdhglksjdghakfhslakdhglksjdgh', 20, '...');

?>

shmusie

I think you actually want to limit the number of records returned?
in which case select * from stuff where status="live" limit 7
susie

shmusie

Doh too! You were talking about text string limit (blush)

bogu

Another approche, mysql only:

SELECT LEFT(text,50), RIGHT(text,50) FROM `table`

LEFT or RIGHT depends from where do u want to cut the text, the last 50 caracters or the first 50 caracters ...
If u want to concat 3 dots at the end or begining...

SELECT CONCAT(LEFT(text,50),'...'), CONCAT('...',RIGHT(text,50)) FROM `table`

exponder

That's actually more like what I was looking for bogu!

Thank you!

I really need to touch up on what I know about mysql. I use it every day, yet I probably only use 10% of what it can actually do.

I see this more and more, php can make you lazy.

Thanks again!