MySQL/SQL retrieve first 40 characters of a text field?

How can I retrieve a text field from mysql db table, but not the entire text, just the few 40 or so characters.

Can this be done in sql or do I need to do it using php?

basically what I am trying to do is show the first x characters and then let the user click on that to view the full content.

Answer

SELECT LEFT(field, 40) AS excerpt FROM table(s) WHERE ...

See the LEFT() function.

As a rule of thumb, you should never do in PHP what MySQL can do for you. Think of it this way: You don’t want to transmit anything more than strictly necessary from the DB to the requesting applications.


EDIT If you’re going to use the entire data on the same page (i.e., with no intermediate request) more often than not, there’s no reason not to fetch the full text at once. (See comments and Veger’s answer.)