Searching columns

[kennyaidan]

hi,
i'm a beginner sql programmer and i was trying to work out how to search a column for a specific string. For example if i had the following column called headline within a table called news

headline|
George Bush gives speech
Dallas win superbowl
virus solution found
Bush talks about future

and if i wanted to return all rows that contained the word "Bush" ie
headline|
George Bush gives speech
Bush talks about future

I tried the following select statement
select * from news where headline = 'bush'
but this only returns rows with only bush solely as its headline

how would i properly construct the select statement.any help greatly appreciated.
Thanks
aidan

 

[swampBoogie]

select * from news where headline like '%bush%'

 

[kennyaidan]

thanks a lot that solved that problem,
thanks again