Skip to content

Instantly share code, notes, and snippets.

@vebodev

vebodev/mysql-search-in-comments.sql

Created July 10, 2023 11:47
Show Gist options
  • Save vebodev/d9ebb594cf1becfe5ff6f21b750714f6 to your computer and use it in GitHub Desktop.
Save vebodev/d9ebb594cf1becfe5ff6f21b750714f6 to your computer and use it in GitHub Desktop.
Download ZIP
Search in all comments
Raw
mysql-search-in-comments.sql
# match text in all tables' comments
SELECT TABLE_NAME, COLUMN_NAME, COLUMN_COMMENT
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'iCRM2_CustomerDB_Saas_xzdyf'
AND COLUMN_COMMENT LIKE '%复购%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment