Server: mysql.puroparty.com

Database: puroparty

Table: jos_contact_details

Structure Browse SQL Search Insert Export Operations Empty Drop

Select fields (at least one): id name alias con_position address suburb state country postcode telephone fax misc image imagepos email_to default_con published checked_out checked_out_time ordering params user_id catid access mobile webpage DISTINCT

Number of rows per page :   Display order: id name alias con_position address suburb state country postcode telephone fax misc image imagepos email_to default_con published checked_out checked_out_time ordering params user_id catid access mobile webpage 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 name 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 con_position varchar(255) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL address text utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL suburb varchar(100) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL state varchar(100) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL country varchar(100) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL postcode varchar(100) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL telephone varchar(255) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL fax varchar(255) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL misc mediumtext utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL image varchar(255) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL imagepos varchar(20) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL email_to varchar(255) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP IS NULL IS NOT NULL default_con tinyint(1) = > >= < <= != LIKE NOT LIKE published tinyint(1) = > >= < <= != LIKE NOT LIKE checked_out int(11) = > >= < <= != LIKE NOT LIKE checked_out_time datetime = > >= < <= != LIKE NOT LIKE ordering int(11) = > >= < <= != LIKE NOT LIKE params text utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP user_id int(11) = > >= < <= != LIKE NOT LIKE catid int(11) = > >= < <= != LIKE NOT LIKE access tinyint(3) = > >= < <= != LIKE NOT LIKE mobile varchar(255) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP webpage varchar(255) utf8_general_ci LIKE LIKE %...% NOT LIKE = != REGEXP NOT REGEXP