Server: mysql.puroparty.com

Database: puroparty

Table: phorum_users

Structure Browse SQL Search Insert Export Operations Empty Drop

Select fields (at least one): user_id username password cookie_sessid_lt sessid_st sessid_st_timeout password_temp email email_temp hide_email active user_data signature threaded_list posts admin threaded_read date_added date_last_active last_active_forum hide_activity show_signature email_notify pm_email_notify tz_offset is_dst user_language user_template moderator_data moderation_email DISTINCT

Number of rows per page :   Display order: user_id username password cookie_sessid_lt sessid_st sessid_st_timeout password_temp email email_temp hide_email active user_data signature threaded_list posts admin threaded_read date_added date_last_active last_active_forum hide_activity show_signature email_notify pm_email_notify tz_offset is_dst user_language user_template moderator_data moderation_email 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(10) = > >= < <= != LIKE NOT LIKE username varchar(50) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP password varchar(50) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP cookie_sessid_lt varchar(50) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP sessid_st varchar(50) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP sessid_st_timeout int(10) = > >= < <= != LIKE NOT LIKE password_temp varchar(50) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP email varchar(100) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP email_temp varchar(110) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP hide_email tinyint(1) = > >= < <= != LIKE NOT LIKE active tinyint(1) = > >= < <= != LIKE NOT LIKE user_data text latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL signature text latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL threaded_list tinyint(4) = > >= < <= != LIKE NOT LIKE posts int(10) = > >= < <= != LIKE NOT LIKE admin tinyint(1) = > >= < <= != LIKE NOT LIKE threaded_read tinyint(4) = > >= < <= != LIKE NOT LIKE date_added int(10) = > >= < <= != LIKE NOT LIKE date_last_active int(10) = > >= < <= != LIKE NOT LIKE last_active_forum int(10) = > >= < <= != LIKE NOT LIKE hide_activity tinyint(1) = > >= < <= != LIKE NOT LIKE show_signature tinyint(1) = > >= < <= != LIKE NOT LIKE email_notify tinyint(1) = > >= < <= != LIKE NOT LIKE pm_email_notify tinyint(1) = > >= < <= != LIKE NOT LIKE tz_offset tinyint(2) = > >= < <= != LIKE NOT LIKE is_dst tinyint(1) = > >= < <= != LIKE NOT LIKE user_language varchar(100) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP user_template varchar(100) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP moderator_data text latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL moderation_email tinyint(2) = > >= < <= != LIKE NOT LIKE