[RESOLVED] Count rows containing a specific word

[JayQ]

How do I make a select statement that counts the total number of rows containing a specific word, lets say the word "sfp".

This is my code atm:

$totalfinished_sql	= "SELECT auction FROM winners WHERE auction = 'sfp'";
$totalfinished_qry	= mysql_query($totalfinished_sql) or die(mysql_error() . "<br>" . $totalfinished_sql);
$totalfinished  = mysql_num_rows($totalfinished_qry);

The table looks like this:

ID----auction
1-----sfp
2-----ace
3-----meg
4-----sfp
5-----box

[nnichols]

SELECT COUNT(*) FROM winners WHERE auction = 'sfp'

[JayQ]

I'm sorry I explained poorly. The table looks like this:
Therefore the count doesn't work because only the beginning of the cells are the same.

ID----auction
1-----sfp3
2-----ace1
3-----meg
4-----sfp2
5-----box2

[nnichols]

SELECT COUNT(*) FROM winners WHERE auction LIKE 'sfp%'

Read this -dev.mysql.com