Server:
mysql.puroparty.com
Database:
puroparty
Table:
jos_banner
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Select fields (at least one):
bid
cid
type
name
alias
imptotal
impmade
clicks
imageurl
clickurl
date
showBanner
checked_out
checked_out_time
editor
custombannercode
catid
description
sticky
ordering
publish_up
publish_down
tags
params
DISTINCT
Number of rows per page :
Display order:
bid
cid
type
name
alias
imptotal
impmade
clicks
imageurl
clickurl
date
showBanner
checked_out
checked_out_time
editor
custombannercode
catid
description
sticky
ordering
publish_up
publish_down
tags
params
Ascending
Descending
Add search conditions (body of the "where" clause):
Or
Do a "query by example" (wildcard: "%")
Field
Type
Collation
Operator
Value
bid
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
cid
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
type
varchar(30)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
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
imptotal
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
impmade
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
clicks
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
imageurl
varchar(100)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
clickurl
varchar(200)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
date
datetime
=
>
>=
<
<=
!=
LIKE
NOT LIKE
IS NULL
IS NOT NULL
showBanner
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
checked_out
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
checked_out_time
datetime
=
>
>=
<
<=
!=
LIKE
NOT LIKE
editor
varchar(50)
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
custombannercode
text
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
IS NULL
IS NOT NULL
catid
int(10)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
description
text
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
sticky
tinyint(1)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
ordering
int(11)
=
>
>=
<
<=
!=
LIKE
NOT LIKE
publish_up
datetime
=
>
>=
<
<=
!=
LIKE
NOT LIKE
publish_down
datetime
=
>
>=
<
<=
!=
LIKE
NOT LIKE
tags
text
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP
params
text
utf8_general_ci
LIKE
LIKE %...%
NOT LIKE
=
!=
REGEXP
NOT REGEXP