xionhack Posted October 2, 2010 Share Posted October 2, 2010 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! Link to comment https://forums.phpfreaks.com/topic/214980-find-blogspotcom-in-a-link/ Share on other sites More sharing options...
jskywalker Posted October 2, 2010 Share Posted October 2, 2010 this is a SQL question......... (so wrong place of forum?) SELECT * from blog_addresses WHERE link like '%.blogspot.com%'; Link to comment https://forums.phpfreaks.com/topic/214980-find-blogspotcom-in-a-link/#findComment-1118308 Share on other sites More sharing options...
BlueSkyIS Posted October 2, 2010 Share Posted October 2, 2010 if you just want matches where the blogs END with .blogspot.com, remove the last % in that SELECT. otherwise, you'll get blogs that CONTAIN .blogspot.com anywhere in the name. Link to comment https://forums.phpfreaks.com/topic/214980-find-blogspotcom-in-a-link/#findComment-1118400 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.