I need a SQL sentence to catch specific rows containing specific strings in a column named: 'TestColumn' in a Table named: TestTable'. A SELECT sentence in SQL is enough at this moment of the project.
The version of the mysql is 5.6 and here you have the link for the support: [login to view URL]
The match conditions are the following:
1. String only contain numbers [0-9]
2. The string is longer of 5 digits.
3. The string does not contain all same digit. Ej: 1111111, or 2222222, or 0000000
4. There are no spaces in the string or other characters