SQL Query

A real simple question, but need some guidance here.

I want to create a narrowed search that queries a database of institutions based on user preferences. I have a field called MAJORS, which is longtext, and it contains a list of majors, separated by newlines. I want to be able to allow a user to input a certain major "Computer Science", lets say, and the query should be able to search within that longtext for "Computer Science".

The normal query structure, select * from table where blabla like blabla, doesn't seem to work.

How can I do this?

Thanks,
Sana

That depends on the SQL engine you are using. In MySQL you can use wildcards with the LIKE operator:

select * from table where column LIKE '%something%';

The % is the wildcard operator.