Server:
mysql.puroparty.com
Database:
puroparty
Table:
jos_menu
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Select fields (at least one):
id
menutype
name
alias
link
type
published
parent
componentid
sublevel
ordering
checked_out
checked_out_time
pollid
browserNav
access
utaccess
params
lft
rgt
home
DISTINCT
Number of rows per page :
Display order:
id
menutype
name
alias
link
type
published
parent
componentid
sublevel
ordering
checked_out
checked_out_time
pollid
browserNav
access
utaccess
params
lft
rgt
home
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
menutype
varchar(75)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
name
varchar(255)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
alias
varchar(255)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
link
text
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
type
varchar(50)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
published
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
parent
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
componentid
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
sublevel
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
ordering
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
checked_out
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
checked_out_time
datetime
=
>
>=
<
<=
!=
LIKE
NOT LIKE
pollid
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
browserNav
tinyint(4)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
access
tinyint(3)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
utaccess
tinyint(3)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
params
text
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
lft
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
rgt
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
home
int(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE