select where character length is greater than

[s0c0]

I am looking for a query a that will allow me to select all where charecter length in a given column is greater than 5.  I ahve tried the following:

 

SELECT * FROM tbl WHERE CHAR_LENGTH(col) > 5;

 

But mysql returns an error near CHAR_LENGTH.  Any ideas?

[bubblegum.anarchy]

The query looks fine syntactically, maybe the tbl prefix is an issue... try again with the table name and column names wrapped in backticks:

 

SELECT * FROM `tbl` WHERE CHAR_LENGTH(`col`) > 5;