SELECT `uid`, `company`,`description`,`address`,`city`,`state`,`country`,`zip`,`phone`,`uid`,`website` FROM `member` WHERE status ='a' AND ( company LIKE '%%' OR city LIKE '%%' OR description LIKE '%%' OR keywords LIKE '%%')