Server: mysql.puroparty.com

Database: puroparty

Table: photopost_photos

Structure Browse SQL Search Insert Export Operations Empty Drop

Select fields (at least one): id user userid cat storeid storecat date title description keywords bigimage width height filesize views medwidth medheight medsize approved lastpost rating watermarked allowprint extra1 extra2 extra3 extra4 extra5 extra6 disporder ipaddress numcom lastposter lastpid allowrate allowcoms DISTINCT

Number of rows per page :   Display order: id user userid cat storeid storecat date title description keywords bigimage width height filesize views medwidth medheight medsize approved lastpost rating watermarked allowprint extra1 extra2 extra3 extra4 extra5 extra6 disporder ipaddress numcom lastposter lastpid allowrate allowcoms Ascending Descending

Add search conditions (body of the "where" clause):
Or Do a "query by example" (wildcard: "%")
Field Type Collation Operator Value id int(10) = > >= < <= != LIKE NOT LIKE user varchar(50) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP userid int(8) = > >= < <= != LIKE NOT LIKE cat int(11) = > >= < <= != LIKE NOT LIKE storeid int(12) = > >= < <= != LIKE NOT LIKE storecat int(12) = > >= < <= != LIKE NOT LIKE date int(15) = > >= < <= != LIKE NOT LIKE title varchar(75) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL description text latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL keywords varchar(150) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL bigimage varchar(100) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP width smallint(6) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL height smallint(4) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL filesize int(10) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL views int(10) = > >= < <= != LIKE NOT LIKE medwidth int(12) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL medheight smallint(6) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL medsize mediumint(9) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL approved tinyint(2) = > >= < <= != LIKE NOT LIKE lastpost int(15) = > >= < <= != LIKE NOT LIKE rating float(12,2) = > >= < <= != LIKE NOT LIKE watermarked varchar(5) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP allowprint varchar(5) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP extra1 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL extra2 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL extra3 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL extra4 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL extra5 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL extra6 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL disporder int(5) = > >= < <= != LIKE NOT LIKE ipaddress varchar(32) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL numcom int(8) = > >= < <= != LIKE NOT LIKE lastposter varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL lastpid int(8) = > >= < <= != LIKE NOT LIKE allowrate int(1) = > >= < <= != LIKE NOT LIKE allowcoms int(1) = > >= < <= != LIKE NOT LIKE