查询条件优化

查询开头是“内容”的数据

select * from message_1 where content like "%内容%";
select * from message_1 where instr(content, "内容") > 0;
select  * from message_1 where locate("内容", content) > 0;