Solution 1: Following piece of code will help you out (without Full Text Search)
Suppose, column value in my database is 'University of Madras' and name of column is 'University_Name' and tableName is StudentDetails
select * from StudentDetails where University_Name like '%Madras%' and University_Name like '%University%'
Solution 2 Following piece of code will help you out (with Full Text Search)
SELECT * FROM StudentDetails WHERE contains(University_Name,'Madras and University')