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

by 
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.)

More Related Contents:

  1. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE `id` [closed]
  2. Using PHP data in MySQL [closed]
  3. Checking the availability of rooms
  4. How to properly set up a PDO connection
  5. Commands out of sync; you can’t run this command now
  6. SELECT COUNT(*) AS count – How to use this count
  7. Get table column names in MySQL?
  8. How to resolve ambiguous column names when retrieving results?
  9. Loading .sql files from within PHP
  10. selecting unique values from a column
  11. Use bound parameter multiple times
  12. MySQL “NOT IN” query 3 tables
  13. Create a dynamic mysql query using php variables
  14. PHP: multiple SQL queries in one mysql_query statement
  15. How to separate DATE and TIME from DATETIME in MySQL?
  16. Why does this return Resource id #2? [duplicate]
  17. MySQL skipping first row
  18. How to reverse order output of a MySQL query
  19. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  20. How to generate unique id in MySQL?
  21. MySql PHP select count of distinct values from comma separated data (tags)
  22. How to SELECT DEFAULT value of a field
  23. how do I get month from date in mysql
  24. php/mysql zip code proximity search
  25. Do I have to use mysql_real_escape_string if I bind parameters?
  26. Updating column so that it contains the row position
  27. PDO and MySQL ‘between’
  28. MySQL Join Multiple Rows as Columns
  29. Aggregated query without GROUP BY
  30. Limit pagination page number

Leave a Comment