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  →
Raw data Post info Pure Ascii HeaderThursday September 29, 2005

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

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
|    entry link Permalink:Short   |  Comments ( 0 comment )   |  # 3    |
Raw data Post info Pure Ascii HeaderThursday September 29, 2005

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

|    entry link Permalink:Short   |  Comments ( 0 comment )   |  # 4    |
←  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