Advertisement
Advertisement


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.

2008/10/08
1
2
10/8/2008 10:37:41 PM

Accepted Answer

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

% is the wild card matcher.

2008/08/22
2
8/22/2008 2:28:06 PM

Look into the LIKE clause

2008/08/22

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%'
2008/08/22

Source: https://stackoverflow.com/questions/22474
Licensed under: CC-BY-SA with attribution
Not affiliated with: Stack Overflow
Email: [email protected]