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.