Server: mysql.puroparty.com

Database: puroparty

Table: bak_menu

Structure Browse SQL Search Insert Export Operations Empty Drop

Select fields (at least one): id menutype name alias link type published parent componentid sublevel ordering checked_out checked_out_time pollid browserNav access utaccess params lft rgt home DISTINCT

Number of rows per page :   Display order: id menutype name alias link type published parent componentid sublevel ordering checked_out checked_out_time pollid browserNav access utaccess params lft rgt home 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 menutype varchar(75) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL name varchar(255) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL 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 IS NULL IS NOT NULL type varchar(50) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP published tinyint(1) = > >= < <= != LIKE NOT LIKE parent int(11) = > >= < <= != LIKE NOT LIKE componentid int(11) = > >= < <= != LIKE NOT LIKE sublevel int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL ordering int(11) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL checked_out int(11) = > >= < <= != LIKE NOT LIKE checked_out_time datetime = > >= < <= != LIKE NOT LIKE pollid int(11) = > >= < <= != LIKE NOT LIKE browserNav tinyint(4) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL access tinyint(3) = > >= < <= != LIKE NOT LIKE utaccess tinyint(3) = > >= < <= != LIKE NOT LIKE params text utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP lft int(11) = > >= < <= != LIKE NOT LIKE rgt int(11) = > >= < <= != LIKE NOT LIKE home int(1) = > >= < <= != LIKE NOT LIKE