Server: mysql.puroparty.com

Database: puroparty

Table: jos_users

Structure Browse SQL Search Insert Export Operations Empty Drop

Select fields (at least one): id name username email password usertype block sendEmail gid registerDate lastvisitDate activation params DISTINCT

Number of rows per page :   Display order: id name username email password usertype block sendEmail gid registerDate lastvisitDate activation params Ascending Descending

Add search conditions (body of the "where" clause):
Or Do a "query by example" (wildcard: "%")
Field Type Collation Operator Value id int(11) = > >= < <= != LIKE NOT LIKE name varchar(255) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP username varchar(150) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP email varchar(100) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP password varchar(100) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP usertype varchar(25) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP block tinyint(4) = > >= < <= != LIKE NOT LIKE sendEmail tinyint(4) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL gid tinyint(3) = > >= < <= != LIKE NOT LIKE registerDate datetime = > >= < <= != LIKE NOT LIKE lastvisitDate datetime = > >= < <= != LIKE NOT LIKE activation varchar(100) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP params text utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP