csdear/sqlWildCard_LIKE_.sql

Created May 16, 2014 13:40

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/csdear/893924647578d9d748ca.js"></script>
Save csdear/893924647578d9d748ca to your computer and use it in GitHub Desktop.

Download ZIP

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.

Raw

sqlWildCard_LIKE_.sql


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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment