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