回答編集履歴
2
誤字修正
test
CHANGED
|
@@ -56,7 +56,7 @@
|
|
|
56
56
|
|
|
57
57
|
```sql
|
|
58
58
|
|
|
59
|
-
SELECT * FROM `user` WHERE (( `name` LIKE '%
|
|
59
|
+
SELECT * FROM `user` WHERE (( `name` LIKE '%XXX%' ) OR ( `yomi` LIKE '%XXX%' ))
|
|
60
60
|
|
|
61
61
|
```
|
|
62
62
|
|
1
ドキュメントのURL追加
test
CHANGED
|
@@ -29,3 +29,37 @@
|
|
|
29
29
|
```
|
|
30
30
|
|
|
31
31
|
上記のSQLが実行されます。
|
|
32
|
+
|
|
33
|
+
|
|
34
|
+
|
|
35
|
+
|
|
36
|
+
|
|
37
|
+
where_any_isを利用してもなんとかできそうですね。
|
|
38
|
+
|
|
39
|
+
```php
|
|
40
|
+
|
|
41
|
+
$res = ORM::for_table('table')
|
|
42
|
+
|
|
43
|
+
->where_any_is(array(
|
|
44
|
+
|
|
45
|
+
array('name' => '%XXX%'),
|
|
46
|
+
|
|
47
|
+
array('yomi' => '%XXX%')),
|
|
48
|
+
|
|
49
|
+
array('name' => "LIKE", 'yomi' => "LIKE"))
|
|
50
|
+
|
|
51
|
+
->findArray();
|
|
52
|
+
|
|
53
|
+
```
|
|
54
|
+
|
|
55
|
+
|
|
56
|
+
|
|
57
|
+
```sql
|
|
58
|
+
|
|
59
|
+
SELECT * FROM `user` WHERE (( `name` LIKE '%user%' ) OR ( `yomi` LIKE '%desu%' ))
|
|
60
|
+
|
|
61
|
+
```
|
|
62
|
+
|
|
63
|
+
|
|
64
|
+
|
|
65
|
+
[idiormドキュメント](https://idiorm.readthedocs.io/en/latest/querying.html#filtering-results)
|