public static function selectRowsByKeywords($condition, $keywords)
{
$queryCondition = " WHERE {$condition}";
$query = "SELECT *,(MATCH (`job_title`,`job_description`) AGAINST ('{$keywords}')) as `relevance` FROM " . static::tableName() . "{$queryCondition};";
return MysqliConnection::getConnection()->query($query);
}
protected static function fieldSearch($fieldValue, $fieldName)
{
$query = "SELECT * FROM " . static::tableName() . " WHERE {$fieldName} = {$fieldValue}";
return MysqliConnection::getConnection()->query($query);
}
