沧海一粟

select * FROM table WHERE keyword LIKE 'field%'

SELECT * FROM table WHERE LOCATE('field',keyword)>0;

SELECT * FROM table WHERE INSTR(keyword,'field')>0;