Server: mysql.puroparty.com

Database: puroparty

Table: photopost_categories

Structure Browse SQL Search Insert Export Operations Empty Drop

Select fields (at least one): id catname description catorder thumbs parent header footer headtags private ugnoview ugnoupload ugnopost ugnovote ugnoanno children albums subalbum lastpost lastphoto photos posts password cattype theme thumbtype catdepth watermark sortorder extra1 extra2 extra3 extra4 extra5 extra6 thumbnail maximages canzip frames intro introtitle introcopy moderators numextra ratingtype takevotes ismember DISTINCT

Number of rows per page :   Display order: id catname description catorder thumbs parent header footer headtags private ugnoview ugnoupload ugnopost ugnovote ugnoanno children albums subalbum lastpost lastphoto photos posts password cattype theme thumbtype catdepth watermark sortorder extra1 extra2 extra3 extra4 extra5 extra6 thumbnail maximages canzip frames intro introtitle introcopy moderators numextra ratingtype takevotes ismember Ascending Descending

Add search conditions (body of the "where" clause):
Or Do a "query by example" (wildcard: "%")
Field Type Collation Operator Value id int(12) = > >= < <= != LIKE NOT LIKE catname varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP description varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL catorder mediumint(4) = > >= < <= != LIKE NOT LIKE thumbs varchar(4) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP parent int(5) = > >= < <= != LIKE NOT LIKE header varchar(200) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL footer varchar(200) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL headtags varchar(200) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL private varchar(5) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ugnoview varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL ugnoupload varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL ugnopost varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL ugnovote varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL ugnoanno varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL children text latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL albums text latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL subalbum int(12) = > >= < <= != LIKE NOT LIKE lastpost int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL lastphoto int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL photos int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL posts int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL password varchar(24) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL cattype varchar(4) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP theme varchar(32) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL thumbtype int(2) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL catdepth varchar(6) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL watermark varchar(250) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP sortorder int(2) = > >= < <= != LIKE NOT LIKE extra1 varchar(250) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL extra2 varchar(250) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL extra3 varchar(250) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL extra4 varchar(250) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL extra5 varchar(250) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL extra6 varchar(250) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL thumbnail int(15) = > >= < <= != LIKE NOT LIKE maximages int(12) = > >= < <= != LIKE NOT LIKE canzip char(3) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP frames varchar(32) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP intro char(3) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP introtitle varchar(128) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL introcopy text latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL moderators text latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL numextra int(3) = > >= < <= != LIKE NOT LIKE ratingtype int(1) = > >= < <= != LIKE NOT LIKE takevotes int(1) = > >= < <= != LIKE NOT LIKE ismember smallint(1) = > >= < <= != LIKE NOT LIKE