Server: mysql.puroparty.com

Database: puroparty

Table: photopost_users

Structure Browse SQL Search Insert Export Operations Empty Drop

Select fields (at least one): userid usergroupid username password email homepage icq aim yahoo joindate posts birthday ipaddress location interests occupation bio site offset views cellphone DISTINCT

Number of rows per page :   Display order: userid usergroupid username password email homepage icq aim yahoo joindate posts birthday ipaddress location interests occupation bio site offset views cellphone Ascending Descending

Add search conditions (body of the "where" clause):
Or Do a "query by example" (wildcard: "%")
Field Type Collation Operator Value userid int(25) = > >= < <= != LIKE NOT LIKE usergroupid int(5) = > >= < <= != LIKE NOT LIKE username varchar(30) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP password varchar(50) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP email varchar(75) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP homepage varchar(100) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL icq varchar(50) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL aim varchar(30) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL yahoo varchar(30) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL joindate int(25) = > >= < <= != LIKE NOT LIKE posts int(20) = > >= < <= != LIKE NOT LIKE birthday date = > >= < <= != LIKE NOT LIKE ipaddress varchar(18) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL location varchar(100) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL interests varchar(250) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL occupation varchar(250) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL bio varchar(250) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL site varchar(30) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL offset smallint(2) = > >= < <= != LIKE NOT LIKE views int(10) = > >= < <= != LIKE NOT LIKE cellphone varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL