[SOLVED] Partial Search Query

SELECT text FROM table_name WHERE name = $name

SELECT this FROM that_table WHERE name LIKE '%$name - %'

class search {
function searchFor($s) {
    global $blog;
    $blog->connectDB;
    $sql = "SELECT * FROM $blog->blogtbl WHERE title LIKE '%$s%' OR entry LIKE '%$s%' ORDER BY id DESC";
    $query = mysql_query($sql) or die(mysql_error());
    $row_sql = mysql_fetch_assoc($query);
    $total = mysql_num_rows($query);
    $this->total = $total;
        if($total > 0) {
        $this->query = $query;
        return true;
        } else
            {
        return false;
        }
    }
    function showBlogs() {
                while ($row = mysql_fetch_assoc($this->query)) {//echo out the results
                        echo '<div class="blogentry">
                        
                        <h3 class="blogtitle"><strong><a href="/blog/', $row['link'], '">', $row['title'], '</a></strong></h3> - <span class="date">', strftime('%d %b %Y', $row['timestamp']), '</span>
                        
                        <span class="category">', $row['cat'], '</span>
                        
                        <p>', strip_tags(substr($row['entry'], 0, 100)), '.....</p>', // change 100 to be how many characters you want
                        
                        '</div><hr class="break" />';
            }
    }
    function totalBlogs() {
    return $this->total;
    }
}