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?