WHERE number of letters > 2

How is this done?

[mooger35]

What I need to do is pull up all the entries in my database where the number of letters in a field is > 2.

I tried "WHERE strlen(`field`) > 2" but that didn't work. Can someone point me in the right direction?

Thanks.

[ChadSEO]

mooger35,

You're very close, the SQL function for length is 'length'. So:

WHERE length(`field`) > 2

Hope that helps.

Chad

[mooger35]

ahhh so simple. Thanks!