当前位置:Gxlcms > 数据库问题 > SQL LIKE操作符 Thinkphp

SQL LIKE操作符 Thinkphp

时间:2021-07-01 10:21:17 帮助过:26人阅读

* FROM calendar_events WHERE userIds LIKE %,5,% OR userIds LIKE 5,% OR userIds LIKE 5

Thinkphp中,

  1. <span style="color: #800080">$infoWhere</span>[‘userIds‘] = <span style="color: #0000ff">array</span>(‘like‘,<span style="color: #0000ff">array</span>(‘%,‘.<span style="color: #800080">$cur_id</span>,‘%,‘.<span style="color: #800080">$cur_id</span>.‘,%‘,<span style="color: #800080">$cur_id</span>.‘,%‘,<span style="color: #800080">$cur_id</span>),‘OR‘<span style="color: #000000">);
  2. </span><span style="color: #800080">$events</span> = M(‘calendar_events‘<span style="color: #000000">);
  3. </span><span style="color: #800080">$list</span> = <span style="color: #800080">$events</span>
  4. ->where( <span style="color: #800080">$infoWhere</span><span style="color: #000000">)
  5. </span>->field(‘id,text,start_date,end_date,details,subject,userIds‘<span style="color: #000000">)
  6. </span>->order(‘start_date ‘<span style="color: #000000">)
  7. </span>->select();

 

SQL LIKE操作符 Thinkphp

标签:class   text   _id   logs   code   ids   event   end   array   

人气教程排行