Server: mysql.puroparty.com

Database: puroparty

Table: phorum_messages

Structure Browse SQL Search Insert Export Operations Empty Drop

Select fields (at least one): message_id forum_id thread parent_id author subject body email ip status msgid modifystamp user_id thread_count moderator_post sort datestamp meta viewcount closed DISTINCT

Number of rows per page :   Display order: message_id forum_id thread parent_id author subject body email ip status msgid modifystamp user_id thread_count moderator_post sort datestamp meta viewcount closed Ascending Descending

Add search conditions (body of the "where" clause):
Or Do a "query by example" (wildcard: "%")
Field Type Collation Operator Value message_id int(10) = > >= < <= != LIKE NOT LIKE forum_id int(10) = > >= < <= != LIKE NOT LIKE thread int(10) = > >= < <= != LIKE NOT LIKE parent_id int(10) = > >= < <= != LIKE NOT LIKE author varchar(37) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP subject varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP body text latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP email varchar(100) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP ip varchar(255) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP status tinyint(4) = > >= < <= != LIKE NOT LIKE msgid varchar(100) latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP modifystamp int(10) = > >= < <= != LIKE NOT LIKE user_id int(10) = > >= < <= != LIKE NOT LIKE thread_count int(10) = > >= < <= != LIKE NOT LIKE moderator_post tinyint(3) = > >= < <= != LIKE NOT LIKE sort tinyint(4) = > >= < <= != LIKE NOT LIKE datestamp int(10) = > >= < <= != LIKE NOT LIKE meta mediumtext latin1_swedish_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL viewcount int(10) = > >= < <= != LIKE NOT LIKE closed tinyint(4) = > >= < <= != LIKE NOT LIKE