Hi!

Is there a way to use the length of a text value in "where" conditions?

I found this in W3Schools.com for MS Access:
LEN(c) - Returns the length of a text field

Is there something similar in MySQL? If no, is there any other way I can select, for example, all rows where one field's value is no longer than 5 characters?

Thanks,
eyedam

Never tried, but could you not use LENGTH() ?

PHP Code:

$sql = "SELECT * FROM table WHERE LENGTH(myfield) > 10"; 


Oh, thanks! It worked! And I thought I have already tried that...

eyedam