Server: mysql.puroparty.com

Database: puroparty

Table: extcal_1users

Structure Browse SQL Search Insert Export Operations Empty Drop

Table for calendar users

Select fields (at least one): user_id username password firstname lastname group_id lastvisit email user_regdate user_lang user_website user_location user_occupation reg_key user_status DISTINCT

Number of rows per page :   Display order: user_id username password firstname lastname group_id lastvisit email user_regdate user_lang user_website user_location user_occupation reg_key user_status Ascending Descending

Add search conditions (body of the "where" clause):
Or Do a "query by example" (wildcard: "%")
Field Type Collation Operator Value user_id int(11) = > >= < <= != LIKE NOT LIKE username varchar(30) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP password varchar(64) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP firstname varchar(64) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL lastname varchar(64) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL group_id int(11) = > >= < <= != LIKE NOT LIKE lastvisit datetime = > >= < <= != LIKE NOT LIKE email varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP user_regdate datetime = > >= < <= != LIKE NOT LIKE user_lang varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP user_website varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP user_location varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP user_occupation varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP reg_key varchar(64) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL user_status tinyint(1) = > >= < <= != LIKE NOT LIKE