Server: mysql.puroparty.com

Database: puroparty

Table: djs

Structure Browse SQL Search Insert Export Operations Empty Drop

Select fields (at least one): id name phone1 phone2 type website location smallpic largepic DISTINCT

Number of rows per page :   Display order: id name phone1 phone2 type website location smallpic largepic Ascending Descending

Add search conditions (body of the "where" clause):
Or Do a "query by example" (wildcard: "%")
Field Type Collation Operator Value id smallint(4) = > >= < <= != LIKE NOT LIKE name varchar(50) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP phone1 varchar(15) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP phone2 varchar(15) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP type varchar(50) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP website varchar(50) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP location varchar(35) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP smallpic varchar(35) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP largepic varchar(35) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP