MySQL - instr

http://dev.mysql.com/doc/refman/5.7/en/string-functions.html#function_instr

instr - if substring is present, it returns a +ve number, else it returns a 0
Note: if not present, it returns a 0 and not a negative number (like -1)