HAVING LENGTH(field) in MySQL

Question

I'm trying to select rows with field timestamp, which has a length shorter than 16 characters. I've tried the following:

SELECT LENGTH(timestamp), id
FROM my_table
HAVING LENGTH(timestamp) < 16

But I get this error:

#1054 - Unknown column 'timestamp' in 'having clause'

Any suggestions?

Answer 1

I think you want:

SELECT LENGTH(`timestamp`), id
FROM my_table
WHERE LENGTH(`timestamp`) < 16

Or if you're actually trying to group the results...

SELECT LENGTH(`timestamp`)
FROM my_table
GROUP BY LENGTH(`timestamp`)
HAVING LENGTH(`timestamp`) < 16

Note the backticks (`) in each example to escape the column name.