Server: mysql.puroparty.com

Database: puroparty

Table: email_users

Structure Browse SQL Search Insert Export Operations Empty Drop

InnoDB free: 738304 kB

Select fields (at least one): userid username password admintype listadmintype templateadmintype segmentadmintype status fullname emailaddress settings editownsettings usertimezone textfooter htmlfooter maxlists perhour permonth unlimitedmaxemails maxemails infotips smtpserver smtpusername smtppassword smtpport createdate lastloggedin forgotpasscode usewysiwyg xmlapi xmltoken gettingstarted DISTINCT

Number of rows per page :   Display order: userid username password admintype listadmintype templateadmintype segmentadmintype status fullname emailaddress settings editownsettings usertimezone textfooter htmlfooter maxlists perhour permonth unlimitedmaxemails maxemails infotips smtpserver smtpusername smtppassword smtpport createdate lastloggedin forgotpasscode usewysiwyg xmlapi xmltoken gettingstarted Ascending Descending

Add search conditions (body of the "where" clause):
Or Do a "query by example" (wildcard: "%")
Field Type Collation Operator Value userid int(11) = > >= < <= != LIKE NOT LIKE username varchar(255) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL password varchar(32) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL admintype char(1) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL listadmintype char(1) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL templateadmintype char(1) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL segmentadmintype char(1) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL status char(1) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL fullname varchar(255) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL emailaddress varchar(100) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL settings text utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL editownsettings char(1) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL usertimezone varchar(10) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL textfooter mediumtext utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL htmlfooter mediumtext utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL maxlists int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL perhour int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL permonth int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL unlimitedmaxemails char(1) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL maxemails int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL infotips char(1) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL smtpserver varchar(255) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL smtpusername varchar(255) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL smtppassword varchar(255) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL smtpport int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL createdate int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL lastloggedin int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL forgotpasscode varchar(32) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL usewysiwyg char(1) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL xmlapi char(1) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL xmltoken varchar(40) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL gettingstarted int(11) = > >= < <= != LIKE NOT LIKE