MySQL Select Query – Get only first 10 characters of a value

by

Using the below line

SELECT LEFT(subject , 10) FROM tbl

MySQL Doc.

More Related Contents:

  1. Recreating a query using INNER JOIN? [duplicate]
  2. What is better subquery vs literal on IN clause in mysql
  3. SQL query return data from multiple tables
  4. quick selection of a random row from a large table in mysql
  5. MySQL SELECT only not null values
  6. Ordering by specific field value first
  7. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  8. Checking multiple columns for one value
  9. MySQL #1093 – You can’t specify target table ‘giveaways’ for update in FROM clause
  10. MySQL INSERT INTO … VALUES and SELECT
  11. MySQL error 1241: Operand should contain 1 column(s)
  12. How to select one row randomly taking into account a weight?
  13. quick selection of a random row from a large table in mysql
  14. Compare only day and month with date field in mysql
  15. Syntax error when using except in a query
  16. SELECT query return 1 row from each group
  17. MySQL INNER JOIN select only one row from second table
  18. SQL query to check if a name begins and ends with a vowel
  19. How to SELECT by MAX(date)?
  20. Left Outer Join doesn’t return all rows from my left table?
  21. MySQL: is a SELECT statement case sensitive?
  22. Can a foreign key reference a non-unique index?
  23. Get the latest date from grouped MySQL data
  24. SQL keys, MUL vs PRI vs UNI
  25. How to change the default port of mysql from 3306 to 3360
  26. How to move columns in a MySQL table?
  27. Is it possible to reference one column as multiple foreign keys?
  28. How can we find gaps in sequential numbering in MySQL?
  29. mysql select id and name from other table and join query
  30. SQL query with avg and group by

Leave a Comment