[RESOLVED] Check String Length MySQL

[webmasternovis]

Hi all,

I need to search a database and return the results where a certain column has strings of x characters. Does anyone know if this is possible?

For example, if there is a database of numbers, just return the four figure ones.

Thanks,
Mike

[bradgrafelman]

SELECT column1, column2 FROM myTable WHERE LENGTH(num_column) = 4

[webmasternovis]

Thanks for that, works perfect!

[bradgrafelman]

Don't forget to mark this thread resolved.