Server:
mysql.puroparty.com
Database:
puroparty
Table:
jos_contact_details
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Select fields (at least one):
id
name
alias
con_position
address
suburb
state
country
postcode
telephone
fax
misc
image
imagepos
email_to
default_con
published
checked_out
checked_out_time
ordering
params
user_id
catid
access
mobile
webpage
DISTINCT
Number of rows per page :
Display order:
id
name
alias
con_position
address
suburb
state
country
postcode
telephone
fax
misc
image
imagepos
email_to
default_con
published
checked_out
checked_out_time
ordering
params
user_id
catid
access
mobile
webpage
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(255)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
alias
varchar(255)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
con_position
varchar(255)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
address
text
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
suburb
varchar(100)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
state
varchar(100)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
country
varchar(100)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
postcode
varchar(100)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
telephone
varchar(255)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
fax
varchar(255)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
misc
mediumtext
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
image
varchar(255)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
imagepos
varchar(20)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
email_to
varchar(255)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
default_con
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
published
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
checked_out
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
checked_out_time
datetime
=
>
>=
<
<=
!=
LIKE
NOT LIKE
ordering
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
params
text
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
user_id
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
catid
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
access
tinyint(3)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
mobile
varchar(255)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
webpage
varchar(255)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP