Server:
mysql.puroparty.com
Database:
puroparty
Table:
extcal_2users
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Table for calendar users
Select fields (at least one):
user_id
username
password
firstname
lastname
group_id
lastvisit
email
user_regdate
user_lang
user_website
user_location
user_occupation
reg_key
user_status
DISTINCT
Number of rows per page :
Display order:
user_id
username
password
firstname
lastname
group_id
lastvisit
email
user_regdate
user_lang
user_website
user_location
user_occupation
reg_key
user_status
Ascending
Descending
Add search conditions (body of the "where" clause):
Or
Do a "query by example" (wildcard: "%")
Field
Type
Collation
Operator
Value
user_id
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
username
varchar(30)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
password
varchar(64)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
firstname
varchar(64)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
lastname
varchar(64)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
group_id
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
lastvisit
datetime
=
>
>=
<
<=
!=
LIKE
NOT LIKE
email
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
user_regdate
datetime
=
>
>=
<
<=
!=
LIKE
NOT LIKE
user_lang
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
user_website
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
user_location
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
user_occupation
varchar(255)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
reg_key
varchar(64)
latin1_swedish_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
user_status
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE