Server: mysql.puroparty.com

Database: puroparty

Table: kxtn

Structure Browse SQL Search Insert Export Operations Empty Drop

Select fields (at least one): rank song playstw playslw video audio lyrics label pic DISTINCT

Number of rows per page :   Display order: rank song playstw playslw video audio lyrics label pic Ascending Descending

Add search conditions (body of the "where" clause):
Or Do a "query by example" (wildcard: "%")
Field Type Collation Operator Value rank int(2) = > >= < <= != LIKE NOT LIKE song varchar(75) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP playstw char(3) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP playslw char(3) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP video varchar(200) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP audio longtext latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP lyrics varchar(200) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP label varchar(50) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP pic varchar(50) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP