PhotoPost Community - View Single Post - Deleting entries directly from the database? Stripping commas from keywords?

styleforum · February 5th, 2008, 01:56 PM

Yeah, I ended up with:

SELECT keywords FROM {$Globals['pp_db_prefix']}photos WHERE keywords <> '' AND cat BETWEEN 512 AND 530

That works because the categories I wanted to pull from are all in a row from 512-530.

February 5th, 2008, 01:56 PM	#7 (permalink)
styleforum Member Verified Customer Join Date: Jan 2008 Posts: 55	Yeah, I ended up with: SELECT keywords FROM {$Globals['pp_db_prefix']}photos WHERE keywords <> '' AND cat BETWEEN 512 AND 530 That works because the categories I wanted to pull from are all in a row from 512-530.