select where column with a %
For special characters (% and _), you need to escape them:

WHERE column LIKE '%[%]%';


or

WHERE column LIKE '%\%%' ESCAPE '\';


This is covered in the documentation for LIKE, in the sections "Using Wildcard Characters as Literals" and "Pattern Matching with the ESCAPE Clause." Your first stop should always be the official documentation.