return yes or no if string found

SELECT IF(LENGTH(SUBSTRING('yo needle', instr('yo needle', 'needle'), LENGTH('yo needle')))>0,1,0) AS result