Jak mám vypsat vyhledávání

<?php

include("connect.php");

$search = mysql_real_escape_string($_GET['search']);
$result = mysql_query("
    SELECT * 
FROM  `users` 
WHERE  `username` 
REGEXP  '$search'
");

       while ($data = mysql_fetch_assoc($result))
      { 

      $username = $data['username'];
      }
?>