How to select the column data contain special charactier for example "/" or" _"

Answer 1

select * from address_table where address like "%special character%"; it means "contains"