The wildcard characters (%) have to be part of the substituted variable, not the query string:
%
FMResultSet *rs = [db executeQuery:@"SELECT * FROM athletes WHERE athlete_name LIKE ?", [NSString stringWithFormat:@"%%%@%%", search_text]];