Asf_Db_AbstractQueryBuilder::notLike

Description

public object notLike(string $columns, mixed $value)

Parameters

columns

数据库字段名称

value

模式匹配的内容

Return Values

操作成功返回 Object, 失败返回 false

Examples

Example #1

<?php
// string(103) "[SQL] SELECT * FROM `test1` WHERE `user` LIKE ? AND `pass` NOT LIKE ? [BVALUES] %sanmao% , %123%"

$select = Asf_Db::QBS();
$select->cols()
    ->from('test1')
    ->like('user', '%sanmao%')
    ->notLike('pass', '%123%');