mysql find constraint by name code example

Example: mysql find db contarint

select *
from information_schema.key_column_usage
where constraint_name='[CONSTRAINT_NAME]'