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