Friday February 10, 2012 @ 20:47:20 GMT+10    ( Weather:  n/a )
Home » Weblog Archives

Powered byD's Bloggie
Weblog » Archive » 2005 » September » Day 29
Browse by day ...
 28 September, 200530 September, 2005 

SQL displaying brief info - 3:49 pm
Coding , SQL  -  poster 

This is how you display the first 100 characters of a string in your DB and add '...' at the back.

Display excerpt from a long string [ Hide ]
[ Highlight ] [ Text ]
SELECT CONCAT(SUBSTRING(acol, 1, 100), IF(LENGTH(acol) > 100, '...', '')) AS brief
FROM atable

SQL Joining - 6:42 pm
Coding , SQL  -  poster 

 28 September, 200530 September, 2005 
$ view_blog.php 2009.09.17 18:16:41 $
Lost? | XML/HTML sitemap | Contact
38.107.179.242 , 19 queries , 0.3162s
Gzip enabled , CSS compressed , JS compressed
Copyright © 2005-2011 Darren's Outpost