SELECT other_details FROM Residents WHERE other_details LIKE '%Miss%'
What are the resident details containing the substring 'Miss'?
SELECT other_details FROM Residents WHERE other_details LIKE ' % Miss % '
select other_details from residents where other_details like value
What are the resident details containing the substring 'Miss ' ?