Server: mysql.puroparty.com

Database: puroparty

Table: bosdevUUS

Structure Browse SQL Search Insert Export Operations Empty Drop

Select fields (at least one): id username password email status last_login bd1 bd2 bd3 bd4 bd5 bc1 bc2 bc3 bc4 bc5 bdir1 bdir2 bdir3 bdir4 bdir5 bm1 bm2 bm3 bm4 bm5 bn1 bn2 bn3 bn4 bn5 bf1 bf2 bf3 bf4 bf5 bdl extraFName extraLName extraAddr1 extraAddr2 extraCity extraState extraPostal extraHPhone extraMPhone DISTINCT

Number of rows per page :   Display order: id username password email status last_login bd1 bd2 bd3 bd4 bd5 bc1 bc2 bc3 bc4 bc5 bdir1 bdir2 bdir3 bdir4 bdir5 bm1 bm2 bm3 bm4 bm5 bn1 bn2 bn3 bn4 bn5 bf1 bf2 bf3 bf4 bf5 bdl extraFName extraLName extraAddr1 extraAddr2 extraCity extraState extraPostal extraHPhone extraMPhone Ascending Descending

Add search conditions (body of the "where" clause):
Or Do a "query by example" (wildcard: "%")
Field Type Collation Operator Value id int(5) = > >= < <= != LIKE NOT LIKE username varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP password varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP email varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP status tinyint(1) = > >= < <= != LIKE NOT LIKE last_login date = > >= < <= != LIKE NOT LIKE bd1 tinyint(2) = > >= < <= != LIKE NOT LIKE bd2 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP bd3 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP bd4 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP bd5 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP bc1 tinyint(2) = > >= < <= != LIKE NOT LIKE bc2 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP bc3 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP bc4 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP bc5 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP bdir1 tinyint(2) = > >= < <= != LIKE NOT LIKE bdir2 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP bdir3 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP bdir4 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP bdir5 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP bm1 tinyint(2) = > >= < <= != LIKE NOT LIKE bm2 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP bm3 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP bm4 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP bm5 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP bn1 tinyint(2) = > >= < <= != LIKE NOT LIKE bn2 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP bn3 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP bn4 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP bn5 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP bf1 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP bf2 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP bf3 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP bf4 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP bf5 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP bdl varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP extraFName varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP extraLName varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP extraAddr1 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP extraAddr2 varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP extraCity varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP extraState varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP extraPostal varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP extraHPhone varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP extraMPhone varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP