Server: mysql.puroparty.com

Database: puroparty

Table: artists

Structure Browse SQL Search Insert Export Operations Empty Drop

Select fields (at least one): id name photo photo2 photo3 bio message ad player folder cd1pic cd1name cd2pic cd2name cd3pic cd3name cd4pic cd4name lyrics thumbnail DISTINCT

Number of rows per page :   Display order: id name photo photo2 photo3 bio message ad player folder cd1pic cd1name cd2pic cd2name cd3pic cd3name cd4pic cd4name lyrics thumbnail 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(100) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP photo varchar(100) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP photo2 varchar(100) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP photo3 varchar(100) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP bio text latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP message text latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ad text latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP player text latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP folder varchar(20) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP cd1pic varchar(100) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP cd1name varchar(100) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP cd2pic varchar(100) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP cd2name varchar(100) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP cd3pic varchar(100) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP cd3name varchar(100) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP cd4pic varchar(100) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP cd4name varchar(100) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP lyrics text latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP thumbnail varchar(100) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP