本文介紹了如何將整理添加到 Laravel 查詢的處理方法，對大家解決問題具有一定的參考價值，需要的朋友們下面隨著小編來一起學習吧！
問題描述
我需要像這樣運行具有 collat??e utf8_bin 的查詢:
I need to run a query having collate utf8_bin like so:
SELECT * FROM `table` WHERE `field`='value' collate utf8_bin;
這僅適用于管理腳本，我不想更新表字符集本身，僅適用于特定查詢.
This is strictly for an admin script and I don't want to update the table charset itself, just for the particular query.
我可以使用 Eloquent ORM 來執行此操作還是需要寫出此查詢?
Can I do this using the Eloquent ORM or do I need to write this query out?
推薦答案
既然可以配置MySQL驅動使用一個:
Since you can configure MySQL driver to use one:
'mysql' => array(
'driver' => 'mysql',
'host' => 'localhost',
'database' => 'database',
'username' => 'root',
'password' => '',
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => '',
),
您可以為您的特定查詢創建不同的連接:
You can create a different connection for your particular query:
'mysql-collation' => array(
'driver' => 'mysql',
'host' => 'localhost',
'database' => 'database',
'username' => 'root',
'password' => '',
'charset' => 'utf8',
'collation' => '<your collation>',
'prefix' => '',
),
并在您的查詢中使用該連接:
And use that connection on your query:
$users = DB::connection('mysql-collation')->select(...);
在模型上，您可能可以通過這種方式設置連接:
On a Model, you probably will be able to set a connection this way:
$posts = new Word;
$posts->setConnection('mysql-collation');
$posts->where(...);
這篇關于如何將整理添加到 Laravel 查詢的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！
【網站聲明】本站部分內容來源于互聯網,旨在幫助大家更快的解決問題，如果有圖片或者內容侵犯了您的權益，請聯系我們刪除處理，感謝您的支持！