Server: mysql.puroparty.com

Database: puroparty

Table: phorum_forums

Structure Browse SQL Search Insert Export Operations Empty Drop

Select fields (at least one): forum_id name active description template folder_flag parent_id list_length_flat list_length_threaded moderation threaded_list threaded_read float_to_top check_duplicate allow_attachment_types max_attachment_size max_totalattachment_size max_attachments pub_perms reg_perms display_ip_address allow_email_notify language email_moderators message_count sticky_count thread_count last_post_time display_order read_length vroot edit_post template_settings count_views display_fixed reverse_threading inherit_id DISTINCT

Number of rows per page :   Display order: forum_id name active description template folder_flag parent_id list_length_flat list_length_threaded moderation threaded_list threaded_read float_to_top check_duplicate allow_attachment_types max_attachment_size max_totalattachment_size max_attachments pub_perms reg_perms display_ip_address allow_email_notify language email_moderators message_count sticky_count thread_count last_post_time display_order read_length vroot edit_post template_settings count_views display_fixed reverse_threading inherit_id Ascending Descending

Add search conditions (body of the "where" clause):
Or Do a "query by example" (wildcard: "%")
Field Type Collation Operator Value forum_id int(10) = > >= < <= != LIKE NOT LIKE name varchar(50) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP active smallint(6) = > >= < <= != LIKE NOT LIKE description text latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL template varchar(50) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP folder_flag tinyint(1) = > >= < <= != LIKE NOT LIKE parent_id int(10) = > >= < <= != LIKE NOT LIKE list_length_flat int(10) = > >= < <= != LIKE NOT LIKE list_length_threaded int(10) = > >= < <= != LIKE NOT LIKE moderation int(10) = > >= < <= != LIKE NOT LIKE threaded_list tinyint(4) = > >= < <= != LIKE NOT LIKE threaded_read tinyint(4) = > >= < <= != LIKE NOT LIKE float_to_top tinyint(4) = > >= < <= != LIKE NOT LIKE check_duplicate tinyint(4) = > >= < <= != LIKE NOT LIKE allow_attachment_types varchar(100) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP max_attachment_size int(10) = > >= < <= != LIKE NOT LIKE max_totalattachment_size int(10) = > >= < <= != LIKE NOT LIKE max_attachments int(10) = > >= < <= != LIKE NOT LIKE pub_perms int(10) = > >= < <= != LIKE NOT LIKE reg_perms int(10) = > >= < <= != LIKE NOT LIKE display_ip_address smallint(5) = > >= < <= != LIKE NOT LIKE allow_email_notify smallint(5) = > >= < <= != LIKE NOT LIKE language varchar(100) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP email_moderators tinyint(1) = > >= < <= != LIKE NOT LIKE message_count int(10) = > >= < <= != LIKE NOT LIKE sticky_count int(10) = > >= < <= != LIKE NOT LIKE thread_count int(10) = > >= < <= != LIKE NOT LIKE last_post_time int(10) = > >= < <= != LIKE NOT LIKE display_order int(10) = > >= < <= != LIKE NOT LIKE read_length int(10) = > >= < <= != LIKE NOT LIKE vroot int(10) = > >= < <= != LIKE NOT LIKE edit_post tinyint(1) = > >= < <= != LIKE NOT LIKE template_settings text latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL count_views tinyint(1) = > >= < <= != LIKE NOT LIKE display_fixed tinyint(1) = > >= < <= != LIKE NOT LIKE reverse_threading tinyint(1) = > >= < <= != LIKE NOT LIKE inherit_id int(10) = > >= < <= != LIKE NOT LIKE IS NULL IS NOT NULL