thinkphp6 json 查询

use think\facade\Db;

$result = Db::table('user')
->where('info->$.name', 'like', '%张三%')
->select();

 

 

$result = Db::table('user')
->whereRaw("JSON_EXTRACT(info, '$.name') LIKE '%张三%'")
->select();

 

 

$result = Db::table('user')
->where('info->\'$.name\'', 'like', '%张三%')
->select();

 

use app\model\User;
use think\facade\Db;

$result = User::where('info->$.name', 'like', '%张三%')
->select();

$result = Db::table('user')
->whereRaw("JSON_SEARCH(info, 'one', '张三') IS NOT NULL")
->select();

 

 

$result = Db::table('user')
->whereRaw("JSON_CONTAINS(info->'$.hobbies', 'reading')")
->select();