MySQL – How to select data by string length

by

You are looking for CHAR_LENGTH() to get the number of characters in a string.

For multi-byte charsets LENGTH() will give you the number of bytes the string occupies, while CHAR_LENGTH() will return the number of characters.

More Related Contents:

  1. What is better subquery vs literal on IN clause in mysql
  2. SQL query return data from multiple tables
  3. quick selection of a random row from a large table in mysql
  4. MySQL: is a SELECT statement case sensitive?
  5. MySQL SELECT only not null values
  6. Combine Multiple child rows into one row MYSQL
  7. MySQL SELECT increment counter
  8. MySQL select statement with CASE or IF ELSEIF? Not sure how to get the result
  9. How to get an age from a D.O.B field in MySQL?
  10. How does MySQL’s ORDER BY RAND() work?
  11. MySQL #1093 – You can’t specify target table ‘giveaways’ for update in FROM clause
  12. MySQL How do you INSERT INTO a table with a SELECT subquery returning multiple rows?
  13. MySQL INSERT INTO … VALUES and SELECT
  14. Mysql select distinct
  15. MySQL error 1241: Operand should contain 1 column(s)
  16. How to select one row randomly taking into account a weight?
  17. Compare only day and month with date field in mysql
  18. mysql select sum group by date
  19. MySQL – SQL_BIG_SELECTS
  20. MySQL INNER JOIN select only one row from second table
  21. MySQL Select Query – Get only first 10 characters of a value
  22. What is the default MySQL JOIN behaviour, INNER or OUTER?
  23. MySQL : retrieve a large select by chunks
  24. MySQL – insert data from another table merged with constants
  25. Insert data into table with result from another select query
  26. How to SELECT by MAX(date)?
  27. How to use Table output from stored MYSQL Procedure
  28. MySQL matching unicode characters with ascii version
  29. MySQL Select Multiple VALUES
  30. mySQL returns all rows when field=0

Leave a Comment