Select rows from database by strlen

mysql string string-length
santa picture santa · Feb 19, 2011 · Viewed 37.5k times · Source

Is there a way to select database table rows where a given value is a certain length, for example, less than 5 chars long?

In PHP that would be strlen.

Is there anything similar in MySQL?

Answer

Derek Prior picture Derek Prior · Feb 19, 2011 
SELECT * FROM table_name WHERE CHAR_LENGTH(column_name) < 5

Related questions

how to convert a string to date in mysql?

I have a string column which acts as a date and I want to select it as a date. Is it possible? My sample data format would be; month/day/year -> 12/31/2011

Read More
How to use GROUP BY to concatenate strings in MySQL?

Basically the question is how to get from this: foo_id foo_name 1 A 1 B 2 C to this: foo_id foo_name 1 A B 2 C

Read More
How to escape single quotes in MySQL

How do I insert a value in MySQL that consist of single or double quotes. i.e This is Ashok's Pen. The single quote will create problems. There might be other escape characters. How do you insert the data properly?

Read More