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! Quote 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%'; Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.