Gallery-dump's logo

View unanswered posts | View active topics It is currently Thu May 25, 2017 8:11 pm



Reply to topic  [ 2 posts ] 
 Mysql help guys? ^^ 
Author Message
Site Admin
User avatar

Joined: Sat Sep 23, 2006 11:18 pm
Posts: 4958
Reply with quote
Post Mysql help guys? ^^
A quick one please, a person asked me to delete all his galleries, except when they're from two specific image hosts.

I can remove all galleries from a person except when they're from ONE host.

But from TWO hosts, I kinda don't see how.

Please, would you have suggestions?

Code:

Code:
select count(*) from table
where username='userid'
and column not like '%imagehost1%'


Code:
select count(*) from table
where username='userid'
and column not like '%imagehost2%'


It's to combine the two that I am stuck.

All suggestions would be welcome ;)

_________________
English Zip Hentai


Tue Dec 06, 2016 3:13 pm
Profile WWW
Site Admin
User avatar

Joined: Sat Sep 23, 2006 11:18 pm
Posts: 4958
Reply with quote
Post Re: Mysql help guys? ^^
I'm dumb.

I didn't believe that select * from where ... and ... not like... and ... not like ... would work. Lost too much time in select from select attempts at filtering. While select * from where ... and ... not like... and ... not like ... perfectly did the job.

Ah well, simple solutions, they're always the best.

Sorry :D

_________________
English Zip Hentai


Tue Dec 06, 2016 11:22 pm
Profile WWW
Display posts from previous:  Sort by  
Reply to topic   [ 2 posts ] 

Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware for PTF.
Beautiful women at Babepedia.