wildcard question

[Chris Kay]

New to mysql. I want to select certain data in a table ive created. The table is called example and has names and ages in it. I want to extract the data with all the people who are in there Twenties. I got some code from a website and rearanged it to suit my needs to get into the database.


$result = mysql_query("SELECT * FROM example WHERE age='2%'")
or die(mysql_error());


// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row
echo $row['name']." - ".$row['age']. "<br />";
}

Like this i cannot see any data. When i change the wildcard in the query to an actual number like 1, it shows the result of the person who is 21.

Why would this happen and how do i go about fixing this proble???


thanks

soianyc