Suggest a feature
×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: SQL
Posted by: Jorge Alcalá
Added: Dec 28, 2018 4:04 PM
Modified: Dec 28, 2018 4:05 PM
Views: 32
Tags: mysql
  1. SELECT * FROM information_schema.columns
  2. WHERE table_schema = 'invent'
  3. AND column_name LIKE 'claprov%'