search query syntex

In MySql
kindly tell me how can i do proper search like google in my site
for example user write "asp.net c#"

so i change it like
select * from table where column like '%asp.net%c#%'

but it return only those data where asp.net and c# both exist in title.

but i want it should return all data no problem it contain

just 'asp.net'
or just contain 'c#'
or it contain both 'asp.net c#'

all three type of data should be return so which query should i make fr this.