CODE EXAMPLE FOR SQL

check if word is in column sql

SELECT * FROM STUDENTS WHERE STUDENTID like '%Searchstring%'