johnnymillergh/like_statement.sql

Created December 16, 2020 02:11

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/johnnymillergh/ca01fe42b1ca1600ff778dd4bd659326.js"></script>
Save johnnymillergh/ca01fe42b1ca1600ff778dd4bd659326 to your computer and use it in GitHub Desktop.

Download ZIP

SQL Like

Raw

like_statement.sql

	SELECT *
	FROM user
	WHERE username LIKE '%/_%' ESCAPE '/';

	SELECT *
	FROM user
	WHERE username LIKE '%\_%';

Author

johnnymillergh commented Dec 16, 2020

The first SQL is a universal LIKE SQL statement to retrieve the fuzzy queries.
The second SQL is a universal LIKE SQL statement to retrieve the fuzzy queries.

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