This topic created in 2331 days ago, the information mentioned may be changed or developed.
模型写法
User::where('foo', 10)->first();
执行的 sql 语句
select * from `users` where `foo` = 10
foo 字段其实是个 varchar
User::where('foo', '10')->first();
执行的 sql 语句, 参数还是被转为 int 了
select * from `users` where `foo` = 10
如果传递其他字符串
User::where('foo', 'abc')->first();
执行的 sql 语句, 参数就是期望值
select * from `users` where `foo` = 'abc'
laravel5.8
 |
1
iyaozhen Dec 19, 2019 via Android
MySQL 里面试过吗？我记得不区分 10 还是'10'
|
 |
3
ylsc633 Dec 19, 2019
恭喜你 遇到了一个 建立索引,且用了索引字段,但不走索引的情况!
以后可能会被问到! 哈哈哈 |
 |
4
chinvo Dec 19, 2019 via iPhone
我记得 laravel 的 ORM 有个强制类型的参数，太就没用过有点记不清
|
 |
5
zibber Dec 19, 2019
User::where('foo', Db:raw("'10'"))->first();
|
Select Language