sql like

SELECT `id`,`status`,`short_place`,`merchant_id`,`putin_time` FROM `tf_machine` WHERE `status` = 1 AND `merchant_id` <> 0 AND ( `short_place` like '%蚂蚁极致网络会所%' OR place like '%蚂蚁极致网络会所%' ) ORDER BY sale_num desc LIMIT 0,10




$machine_map['_string'] = '`short_place` like \'%' . $_GET['place'] . '%\' OR place like \'%' . $_GET['place'] . '%\'';
% 前后需要用单引号  去掉%和文字间空格


 

posted @ 2019-09-17 14:12  盘思动  阅读(161)  评论(0编辑  收藏  举报