Find fields with certain characters
- by Kemo
I'm trying to SELECT fields with multiple dots ( . ) in their value.
Exactly, I'm trying to find fields with a subdomain as an entry in domain column, e.g.;
SELECT * FROM domains WHERE ( number of dots in domain value bigger than 1 ).
Any suggestions ?