Artsylar Artsylar - 4 years ago 101
PHP Question

PHP - how to select columns that only have 12 character

Example: I want sql to output only rows that have 6 digit of character 'AAAAAA' I don't want rows that have more than that.

Answer Source
"SELECT * FROM table WHERE LENGTH(columnName) = 6" If MySql and
"SELECT * FROM table WHERE LEN(columnName) = 6" If MSSql
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download