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.
Recommended for you: Get network issues from WhatsUp Gold. Not end users.
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