- $sql_extra = ((strlen($search)) ? " AND MATCH (`profile`.`name`, `user`.`nickname`, `pdesc`, `locality`,`region`,`country-name`,`gender`,`marital`,`sexual`,`about`,`romance`,`work`,`education`,`pub_keywords`,`prv_keywords` ) AGAINST ('$search' IN BOOLEAN MODE) " : "");
+
+ $sql_extra = " AND ((`profile`.`name` LIKE '%$search%') OR
+ (`user`.`nickname` LIKE '%$search%') OR
+ (`pdesc` LIKE '%$search%') OR
+ (`locality` LIKE '%$search%') OR
+ (`region` LIKE '%$search%') OR
+ (`country-name` LIKE '%$search%') OR
+ (`gender` LIKE '%$search%') OR
+ (`marital` LIKE '%$search%') OR
+ (`sexual` LIKE '%$search%') OR
+ (`about` LIKE '%$search%') OR
+ (`romance` LIKE '%$search%') OR
+ (`work` LIKE '%$search%') OR
+ (`education` LIKE '%$search%') OR
+ (`pub_keywords` LIKE '%$search%') OR
+ (`prv_keywords` LIKE '%$search%'))";
+ }