[Resolved] Get strings with lenght <X from DB

[jek]

Hi,

I have tried for quite a while now to get strings out of a database that are shorter than a given nuber of characters.

Is there some easy way to do this, something like Select * where ´field´ length < 25?

Thanks in advance / jek

[goldbug]

I think you were close.

My guess:

SELECT * FROM Foo WHERE LENGTH(bar) < 25;

http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#String_functions

[jek]

Thanks a lot mate! It worked like a charm.

/ jek