[SOLVED] WHERE includes? Instead of WHERE exact?

[SEVIZ]

Here is my current query:

SELECT name,num,sup FROM mytable WHERE name='Thomas'

 

I do not get a return because the name is Bill Thomas.  How can I do a WHERE that searches for data that includes the name, as opposed to IS the entire name?  I am sure its easy.  But I am missing it.

[Ken2k7]

SELECT name, num, sup FROM mytable WHERE name LIKE '%Thomas'

[SEVIZ]

That does not work. No entries are returned.

[pugboy]

http://www.htmlite.com/mysql011.php

 

The following code would return anything that has Thomas in it.

 

SELECT name, num, sup FROM mytable WHERE name LIKE '%Thomas%'