Server: mysql.puroparty.com

Database: puroparty

Table: jos_modules

Structure Browse SQL Search Insert Export Operations Empty Drop

Select fields (at least one): id title content ordering position checked_out checked_out_time published module numnews access showtitle params iscore client_id control DISTINCT

Number of rows per page :   Display order: id title content ordering position checked_out checked_out_time published module numnews access showtitle params iscore client_id control 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 text utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP content text utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ordering int(11) = > >= < <= != LIKE NOT LIKE position varchar(50) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL checked_out int(11) = > >= < <= != LIKE NOT LIKE checked_out_time datetime = > >= < <= != LIKE NOT LIKE published tinyint(1) = > >= < <= != LIKE NOT LIKE module varchar(50) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL numnews int(11) = > >= < <= != LIKE NOT LIKE access tinyint(3) = > >= < <= != LIKE NOT LIKE showtitle tinyint(3) = > >= < <= != LIKE NOT LIKE params text utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP iscore tinyint(4) = > >= < <= != LIKE NOT LIKE client_id tinyint(4) = > >= < <= != LIKE NOT LIKE control text utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP