Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adapting the LEFT function 1

Status
Not open for further replies.
sinbadly

sinbadly

Technical User
Mar 16, 2006
126
GB
How can I adapt this code, Experts, please, to say 'miss 4 characters and then begin the LEFT function?'

SELECT id, head, CONCAT(LEFT(story, 120), ' ...') AS bb, DATE_FORMAT(updated, '%d/%m/%y') as ud FROM maths ORDER BY id ");
 
Sort by date Sort by votes
How about:
[tt]
CONCAT(LEFT(SUBSTRING(story,4),120),'...')
[/tt]
 
Upvote 0 Downvote
Sorry, the 4 should have been a 5, and you can also simplify it:
[tt]
CONCAT(SUBSTRING(story,5,120),'...')
[/tt]
 
Upvote 0 Downvote
Terrific, Tony. Thanks very much indeed. Cheers.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bharons
  • Locked
  • Question
function argument value, type or count is invalid
Replies
3
Views
368
bharons
bharons
EdLentz
  • Locked
  • Question
Need to compare two tables and list the differences
Replies
3
Views
408
EdLentz
EdLentz
TheLazyPig
  • Locked
  • Question
Create Stored Function in phpmyadmin 1
Replies
2
Views
244
TheLazyPig
TheLazyPig
Arthur Lewis
  • Locked
  • Question
How to effect a NOWAIT in the LOCK TABLES statement?
Replies
0
Views
130
Arthur Lewis
Arthur Lewis
trandrus
  • Locked
  • Question
incrementing a column without having to query the db first
Replies
4
Views
174
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top