stuart-d2
5/16/2014 - 1:40 PM

SQL LIKE Pattern and Wildcards A. Table Reference B. Where COLUMN NAME C. LIKE '20%' . Percent sign is the wildcard. E.g., '%20', '20%', '

SQL LIKE Pattern and Wildcards A. Table Reference B. Where COLUMN NAME C. LIKE '20%' . Percent sign is the wildcard. E.g., '%20', '20%', '%camry% D. OR column name. If you want to search for the pattern in additional columns.


***
SELECT * FROM seo_templates
WHERE main_copy LIKE '20%'
OR page_title LIKE '20%' 
***