Page 1 of 1

Find .blogspot.com in a link

Posted: Sat Oct 02, 2010 10:23 am
by xionhack
Hello. I have a database with my blog addresses, I want to be able to populate a list of only the blogs that end with .blogspot.com. How can I do that? Thank you!

Re: Find .blogspot.com in a link

Posted: Sat Oct 02, 2010 11:26 am
by requinix
I'm thinking

Code: Select all

WHERE field REGEX "\.blogspot\.com(/|$)"
in your query should do the trick.