Find fields with certain characters

Question

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 ?

Answer 1

You can use regular expressions:

SELECT * FROM domains WHERE domain REGEXP '\\.+'

Assuming you want the dots placed near each other: ...

Answer 2

The string functions don't seem to have anything in that vein, so you may need the REGEXP operator.

Answer 3

You could use

SELECT * FROM domains WHERE ( domain LIKE "%.%.%" ). 

See the MySQL Documentation for String functions for details.