Server:
mysql.puroparty.com
Database:
puroparty
Table:
jos_content
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Select fields (at least one):
id
title
alias
title_alias
introtext
fulltext
state
sectionid
mask
catid
created
created_by
created_by_alias
modified
modified_by
checked_out
checked_out_time
publish_up
publish_down
images
urls
attribs
version
parentid
ordering
metakey
metadesc
access
hits
metadata
DISTINCT
Number of rows per page :
Display order:
id
title
alias
title_alias
introtext
fulltext
state
sectionid
mask
catid
created
created_by
created_by_alias
modified
modified_by
checked_out
checked_out_time
publish_up
publish_down
images
urls
attribs
version
parentid
ordering
metakey
metadesc
access
hits
metadata
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
title
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
title_alias
varchar(255)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
introtext
mediumtext
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
fulltext
mediumtext
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
state
tinyint(3)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
sectionid
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
mask
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
catid
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
created
datetime
=
>
>=
<
<=
!=
LIKE
NOT LIKE
created_by
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
created_by_alias
varchar(255)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
modified
datetime
=
>
>=
<
<=
!=
LIKE
NOT LIKE
modified_by
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
checked_out
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
checked_out_time
datetime
=
>
>=
<
<=
!=
LIKE
NOT LIKE
publish_up
datetime
=
>
>=
<
<=
!=
LIKE
NOT LIKE
publish_down
datetime
=
>
>=
<
<=
!=
LIKE
NOT LIKE
images
text
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
urls
text
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
attribs
text
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
version
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
parentid
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
ordering
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
metakey
text
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
metadesc
text
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
access
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
hits
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
metadata
text
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP