Server: mysql.puroparty.com

Database: puroparty

Table: jos_newsfeeds

Structure Browse SQL Search Insert Export Operations Empty Drop

Select fields (at least one): catid id name alias link filename published numarticles cache_time checked_out checked_out_time ordering rtl DISTINCT

Number of rows per page :   Display order: catid id name alias link filename published numarticles cache_time checked_out checked_out_time ordering rtl Ascending Descending

Add search conditions (body of the "where" clause):
Or Do a "query by example" (wildcard: "%")
Field Type Collation Operator Value catid int(11) = > >= < <= != LIKE NOT LIKE id int(11) = > >= < <= != LIKE NOT LIKE name text utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP 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 filename varchar(200) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL published tinyint(1) = > >= < <= != LIKE NOT LIKE numarticles int(11) = > >= < <= != LIKE NOT LIKE cache_time int(11) = > >= < <= != LIKE NOT LIKE checked_out tinyint(3) = > >= < <= != LIKE NOT LIKE checked_out_time datetime = > >= < <= != LIKE NOT LIKE ordering int(11) = > >= < <= != LIKE NOT LIKE rtl tinyint(4) = > >= < <= != LIKE NOT LIKE