How do I display records containing specific information in SQl

Question

How do I select all records that contain "LCS" within the title column in sql.

Answer 1

SELECT * FROM TABLE WHERE TABLE.TITLE LIKE '%LCS%';

% is the wild card matcher.

Answer 2

Look into the LIKE clause

Answer 3

Are you looking for all the tables with a column name which contains the LCS in them? If yes the do this

select table_name 
from information_schema.columns 
where column_name like '%lcs%'