【Rails】 ransackを使って検索機能がついたアプリを作ろう！

1
2
$ rails _5.2.1_ new ransack_test -d mysql
$ cd ransack_test

1
2
$ rails g scaffold User name:string age:integer height:integer weight:integer gender:string
$ rails db:create && rails db:migrate

1
2
3
4
5
6
7
users = [
  { name: '田中ゆうこ', age: 24, height: 155, weight: 40, gender: '女' },
  { name: '森山太郎', age: 26, height: 167, weight: 60, gender: '男' },
  { name: '山田太郎', age: 34, height: 175, weight: 74, gender: '男' },
  { name: '秋山なお', age: 18, height: 160, weight: 46, gender: '女' }
]
User.create(users)

1
$ rails db:seed

1
gem 'ransack'

1
$ bundle install

1
2
3
4
5
6
7
Rails.application.routes.draw do
  resources :users do
    collection do
      get 'search'
    end
  end
end

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
class UsersController < ApplicationController
  before_action :set_user, only: [:show, :edit, :update, :destroy]
  before_action :set_q, only: [:index, :search]

  def index
    @users = User.all
  end

  def show
  end

  def new
    @user = User.new
  end

  def edit
  end

  def create
    @user = User.new(user_params)

    respond_to do |format|
      if @user.save
        format.html { redirect_to @user, notice: 'User was successfully created.' }
        format.json { render :show, status: :created, location: @user }
      else
        format.html { render :new }
        format.json { render json: @user.errors, status: :unprocessable_entity }
      end
    end
  end

  def update
    respond_to do |format|
      if @user.update(user_params)
        format.html { redirect_to @user, notice: 'User was successfully updated.' }
        format.json { render :show, status: :ok, location: @user }
      else
        format.html { render :edit }
        format.json { render json: @user.errors, status: :unprocessable_entity }
      end
    end
  end

  def destroy
    @user.destroy
    respond_to do |format|
      format.html { redirect_to users_url, notice: 'User was successfully destroyed.' }
      format.json { head :no_content }
    end
  end

  def search
    @results = @q.result
  end

  private

  def set_q
    @q = User.ransack(params[:q])
  end

  def set_user
    @user = User.find(params[:id])
  end

  def user_params
    params.require(:user).permit(:name, :age, :height, :weight, :gender)
  end
end

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
[1] pry(#<UsersController>)> @q
=> Ransack::Search<class: User, base: Grouping <conditions: [Condition <attributes: ["name"], predicate: cont, values: ["田中"]>], combinator: and>>
[2] pry(#<UsersController>)>@results = @q.result
  User Load (0.8ms)  SELECT `users`.* FROM `users` WHERE `users`.`name` LIKE '%田中%'
  ↳ app/controllers/users_controller.rb:69
=> [#<User:0x00007f8e37ae2190
  id: 1,
  name: "田中ゆうこ",
  age: 24,
  height: 155,
  weight: 40,
  gender: "女",
  created_at: XXX, XX Nov 2020 XX:XX:XX UTC +00:00,
  updated_at: XXX, XX Nov 2020 XX:XX:XX UTC +00:00>]

# クラスの確認
[3] pry(#<UsersController>)> @results.class
=> User::ActiveRecord_Relation

1
2
3
4
5
6
7
<h1>ユーザー検索</h1>
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= f.label :name_cont, 'ユーザー名' %>
  <%= f.search_field :name_cont %>
  <br>
  <%= f.submit '検索' %>
<% end %>

1
2
3
4
5
6
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= f.label :name_cont, 'ユーザー名' %>
  <%= f.search_field :name_cont %>
  <br>
  <%= f.submit '検索' %>
<% end %>

1
<form class="user_search" id="user_search" action="/users/search" accept-charset="UTF-8" method="get">

1
2
3
4
5
6
7
<h1>ユーザー検索</h1>
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= f.label :name_cont, 'ユーザー名' %>
  <%= f.search_field :name_cont %>
  <br>
  <%= f.submit '検索' %>
<% end %>

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
<h1>検索結果</h1>
<table>
  <thead>
    <tr>
      <th>Name</th>
      <th>Age</th>
      <th>Height</th>
      <th>Weight</th>
      <th>Gender</th>
      <th colspan="3"></th>
    </tr>
  </thead>

  <tbody>
    <% @results.each do |user| %>
      <tr>
        <td><%= user.name %></td>
        <td><%= user.age %></td>
        <td><%= user.height %></td>
        <td><%= user.weight %></td>
        <td><%= user.gender %></td>
        <td><%= link_to 'Show', user %></td>
        <td><%= link_to 'Edit', edit_user_path(user) %></td>
        <td><%= link_to 'Destroy', user, method: :delete, data: { confirm: 'Are you sure?' } %></td>
      </tr>
    <% end %>
  </tbody>
</table>

<%= link_to 'Top', users_path %>

1
2
3
4
5
6
7
8
9
<!--  略 -->
<h1>ユーザー検索</h1>
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= f.label :name_cont, 'ユーザー名' %>
  <%= f.search_field :name_cont %>
  <%= f.label :age_eq, '年齢' %>
  <%= f.search_field :age_eq %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE (`users`.`name` LIKE '%田中%' AND `users`.`age` = 24)

1
2
3
4
5
6
7
<!--  略 -->
<h1>ユーザー検索</h1>
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= f.label :age_or_height_or_weight_gt, "数値を入力してください" %>
  <%= f.search_field :age_or_height_or_weight_gt %>
  <%= f.submit '検索' %>
<% end %>

1
2
3
4
5
6
7
8
9
10
11
# 〜以下の場合
<%= f.radio_button :カラム名_lteq, '検索する数字' %>表示する文字

# 〜未満の場合
<%= f.radio_button :カラム名_lt, '検索する数字' %>表示する文字

# 〜以上の場合
<%= f.radio_button :カラム名_gteq, '検索する数字' %>表示する文字

# 〜より大きい場合
<%= f.radio_button :カラム名_gt, '検索する数字' %>表示する文字

1
2
3
4
5
6
7
8
9
10
11
12
13
14
<!--  略 -->
<h1>ユーザー検索</h1>
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= f.label :name_cont, 'ユーザー名' %>
  <%= f.search_field :name_cont %>
  <%= f.label :age, '年齢' %>
  <%= f.radio_button :age_lteq, '' %>指定しない
  <%= f.radio_button :age_lteq, '10' %>10歳以下
  <%= f.radio_button :age_lteq, '20' %>20歳以下
  <%= f.radio_button :age_lteq, '30' %>30歳以下
  <%= f.radio_button :age_lteq, '40' %>40歳以下
  <%= f.radio_button :age_gteq, '50' %>50歳以上
  <%= f.submit '検索' %>
<% end %>

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
<!--  略 -->
<h1>ユーザー検索</h1>
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= f.label :name_cont, 'ユーザー名' %>
  <%= f.search_field :name_cont %>
  <%= f.submit '検索' %>
<% end %>

<%= search_form_for @q, url: search_users_path do |f| %>
  <%= f.radio_button :age_lteq, '' %>指定しない
  <%= f.radio_button :age_lteq, '10' %>10歳以下
  <%= f.radio_button :age_lteq, '20' %>20歳以下
  <%= f.radio_button :age_lteq, '30' %>30歳以下
  <%= f.radio_button :age_lteq, '40' %>40歳以下
  <%= f.radio_button :age_gteq, '50' %>50歳以上
  <%= f.submit '検索' %>
<% end %>

1
<%= sort_link(@q, :データベースのカラム名, "表示される文字" %>

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
<p id="notice"><%= notice %></p>

<h1>Users</h1>

<table>
  <thead>
    <tr>
      <th><%= sort_link(@q, :name, "Name") %></th>
      <th><%= sort_link(@q, :age, "Age") %></th>
      <th><%= sort_link(@q, :height, "Height") %></th>
      <th><%= sort_link(@q, :weight, "Weight") %></th>
      <th><%= sort_link(@q, :gender, "Gender") %></th>
      <th colspan="3"></th>
    </tr>
  </thead>

  <tbody>
    <% @results.each do |user| %>
      <tr>
        <td><%= user.name %></td>
        <td><%= user.age %></td>
        <td><%= user.height %></td>
        <td><%= user.weight %></td>
        <td><%= user.gender %></td>
        <td><%= link_to 'Show', user %></td>
        <td><%= link_to 'Edit', edit_user_path(user) %></td>
        <td><%= link_to 'Destroy', user, method: :delete, data: { confirm: 'Are you sure?' } %></td>
      </tr>
    <% end %>
  </tbody>
</table>

<br>

<%= link_to 'New User', new_user_path %>

<h1>ユーザー検索</h1>
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= f.label :name_cont, 'ユーザー名' %>
  <%= f.search_field :name_cont %>
  <%= f.submit '検索' %>
<% end %>

1
2
3
4
5
6
7
8
9
10
11
12
<h1>検索結果</h1>
<table>
  <thead>
    <tr>
      <th><%= sort_link(@q, :name, "Name") %></th>
      <th><%= sort_link(@q, :age, "Age") %></th>
      <th><%= sort_link(@q, :height, "Height") %></th>
      <th><%= sort_link(@q, :weight, "Weight") %></th>
      <th><%= sort_link(@q, :gender, "Gender") %></th>
      <th colspan="3"></th>
    </tr>
  </thead>

1
2
3
def index
  @users = @q.result
end

1
<%= sort_link(@q, :データベースのカラム名, "表示される文字", default_order: :desc %>

1
<%= sort_link(@q, :データベースのカラム名, "表示される文字", hide_indicator: true) %>

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= f.label :name_eq, 'ユーザー名' %>
  <%= f.search_field :name_eq %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE `users`.`name` = '山田太郎'

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= f.label :name_not_eq, 'ユーザー名' %>
  <%= f.search_field :name_not_eq %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE `users`.`name` != '山田太郎'

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= f.label :name_matches, 'ユーザー名' %>
  <%= f.search_field :name_matches %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE `users`.`name` LIKE '山田%'

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= f.label :name_does_not_match,  'ユーザー名' %>
  <%= f.search_field :name_does_not_match %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE `users`.`name` NOT LIKE '山田%'

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= search_field_tag "q[name_matches_any][]" %>
  <%= search_field_tag "q[name_matches_any][]" %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE (`users`.`name` LIKE '%中%' OR `users`.`name` LIKE '%太郎')

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= search_field_tag "q[name_matches_all][]" %>
  <%= search_field_tag "q[name_matches_all][]" %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE (`users`.`name` LIKE '%田%' AND `users`.`name` LIKE '%太郎')

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= search_field_tag "q[name_does_not_match_any][]" %>
  <%= search_field_tag "q[name_does_not_match_any][]" %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE (`users`.`name` NOT LIKE '%田%' OR `users`.`name` NOT LIKE '%太郎')

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= search_field_tag "q[name_does_not_match_all][]" %>
  <%= search_field_tag "q[name_does_not_match_all][]" %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE (`users`.`name` NOT LIKE '%田%' AND `users`.`name` NOT LIKE '%太郎')

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= f.label :age_lt, '年齢' %>
  <%= f.search_field :age_lt %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE `users`.`age` < 26

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= f.label :age_lteq, '年齢' %>
  <%= f.search_field :age_lteq %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE `users`.`age` <= 26

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= f.label :age_gt, '年齢' %>
  <%= f.search_field :age_gt %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE `users`.`age` > 26

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= f.label :age_gteq, '年齢' %>
  <%= f.search_field :age_gteq %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE `users`.`age` >= 26

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= f.label :name_present, 'ユーザー名' %>
  <%= f.search_field :name_present %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE (`users`.`name` IS NOT NULL AND `users`.`name` != '')

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= f.label :name_blank, 'ユーザー名' %>
  <%= f.search_field :name_blank %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE (`users`.`name` IS NULL OR `users`.`name` = '')

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= f.label :name_null, 'ユーザー名' %>
  <%= f.search_field :name_null %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE `users`.`name` IS NULL

1
2
3
4
5
6
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= f.label :name_not_null, 'ユーザー名' %>
  <%= f.search_field :name_not_null %>
  <br>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE `users`.`name` IS NOT NULL

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= search_field_tag "q[name_in][]" %>
  <%= search_field_tag "q[name_in][]" %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE `users`.`name` IN ('田中ゆうこ', '山田太郎')

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= search_field_tag "q[name_not_in][]" %>
  <%= search_field_tag "q[name_not_in][]" %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE `users`.`name` NOT IN ('田中ゆうこ', '山田太郎')

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= search_field_tag "q[age_lt_any][]" %>
  <%= search_field_tag "q[age_lt_any][]" %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE (`users`.`age` < 20 OR `users`.`age` < 26)

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= search_field_tag "q[age_lteq_any][]" %>
  <%= search_field_tag "q[age__lteq_any][]" %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE (`users`.`age` <= 20 OR `users`.`age` <= 26)

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= search_field_tag "q[age_gt_any][]" %>
  <%= search_field_tag "q[age_gt_any][]" %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE (`users`.`age` > 24 OR `users`.`age` > 30)

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= search_field_tag "q[age_gteq_any][]" %>
  <%= search_field_tag "q[age_gteq_any][]" %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE (`users`.`age` >= 24 OR `users`.`age` >= 30)

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= search_field_tag "q[age_lt_all][]" %>
  <%= search_field_tag "q[age_lt_all][]" %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE (`users`.`age` < 24 AND `users`.`age` < 30)

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= search_field_tag "q[age_lteq_all][]" %>
  <%= search_field_tag "q[age_lteq_all][]" %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE (`users`.`age` <= 24 AND `users`.`age` <= 30)

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= search_field_tag "q[age_gt_all][]" %>
  <%= search_field_tag "q[age_gt_all][]" %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE (`users`.`age` > 24 AND `users`.`age` > 30)

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= search_field_tag "q[age_gteq_all][]" %>
  <%= search_field_tag "q[age_gteq_all][]" %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE (`users`.`age` >= 24 AND `users`.`age` >= 34)

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= search_field_tag "q[age_not_eq_all][]" %>
  <%= search_field_tag "q[age_not_eq_all][]" %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE (`users`.`age` != 24 AND `users`.`age` != 34)

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= f.label :name_start, 'ユーザー名' %>
  <%= f.search_field :name_start %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE `users`.`name` LIKE '森%'

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= f.label :name_not_start, 'ユーザー名' %>
  <%= f.search_field :name_not_start %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE `users`.`name` NOT LIKE '森%'

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= search_field_tag "q[name_start_any][]" %>
  <%= search_field_tag "q[name_start_any][]" %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE (`users`.`name` LIKE '森%' OR `users`.`name` LIKE '山%')

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= search_field_tag "q[name_start_all][]" %>
  <%= search_field_tag "q[name_start_all][]" %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE (`users`.`name` LIKE '森%' AND `users`.`name` LIKE '森山%')

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= search_field_tag "q[name_not_start_any][]" %>
  <%= search_field_tag "q[name_not_start_any][]" %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE (`users`.`name` NOT LIKE '森%' OR `users`.`name` NOT LIKE '森山%')

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= search_field_tag "q[name_not_start_all][]" %>
  <%= search_field_tag "q[name_not_start_all][]" %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE (`users`.`name` NOT LIKE '森%' AND `users`.`name` NOT LIKE '山%')

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= f.label :name_end, 'ユーザー名' %>
  <%= f.search_field :name_end %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE `users`.`name` LIKE '%太郎'

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= f.label :name_not_end, 'ユーザー名' %>
  <%= f.search_field :name_not_end %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE `users`.`name` NOT LIKE '%太郎'

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= search_field_tag "q[name_end_any][]" %>
  <%= search_field_tag "q[name_end_any][]" %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE (`users`.`name` LIKE '%ゆうこ' OR `users`.`name` LIKE '%なお')

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= search_field_tag "q[name_end_all][]" %>
  <%= search_field_tag "q[name_end_all][]" %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE (`users`.`name` LIKE '%郎' AND `users`.`name` LIKE '%太郎')

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= search_field_tag "q[name_not_end_any][]" %>
  <%= search_field_tag "q[name_not_end_any][]" %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE (`users`.`name` NOT LIKE '%郎' OR `users`.`name` NOT LIKE '%太郎')

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= search_field_tag "q[name_not_end_all][]" %>
  <%= search_field_tag "q[name_not_end_all][]" %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE (`users`.`name` NOT LIKE '%ゆうこ' AND `users`.`name` NOT LIKE '%なお')

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= f.label :name_cont, 'ユーザー名' %>
  <%= f.search_field :name_cont %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE `users`.`name` LIKE '%田%'

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= search_field_tag "q[name_cont_any][]" %>
  <%= search_field_tag "q[name_cont_any][]" %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE (`users`.`name` LIKE '%森%' OR `users`.`name` LIKE '%中%')

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= search_field_tag "q[name_cont_all][]" %>
  <%= search_field_tag "q[name_cont_all][]" %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE (`users`.`name` LIKE '%森%' AND `users`.`name` LIKE '%田%')

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= f.label :name_not_cont, 'ユーザー名' %>
  <%= f.search_field :name_not_cont %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE `users`.`name` NOT LIKE '%田%'

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= search_field_tag "q[name_not_cont_any][]" %>
  <%= search_field_tag "q[name_not_cont_any][]" %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE (`users`.`name` NOT LIKE '%森%' OR `users`.`name` NOT LIKE '%田%')

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= search_field_tag "q[name_not_cont_all][]" %>
  <%= search_field_tag "q[name_not_cont_all][]" %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE (`users`.`name` NOT LIKE '%森%' AND `users`.`name` NOT LIKE '%田%')

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= f.label :name_i_cont, 'ユーザー名' %>
  <%= f.search_field :name_i_cont %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE LOWER(`users`.`name`) LIKE '%tanaka%'

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= search_field_tag "q[name_i_cont_any][]" %>
  <%= search_field_tag "q[name_i_cont_any][]" %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE (LOWER(`users`.`name`) LIKE '%ta%' OR LOWER(`users`.`name`) LIKE '%mo%')

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= search_field_tag "q[name_i_cont_all][]" %>
  <%= search_field_tag "q[name_i_cont_all][]" %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE (LOWER(`users`.`name`) LIKE '%ta%' AND LOWER(`users`.`name`) LIKE '%mo%')

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= f.label :name_not_i_cont, 'ユーザー名' %>
  <%= f.search_field :name_not_i_cont %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE LOWER(`users`.`name`) NOT LIKE '%ta%'

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= search_field_tag "q[name_not_i_cont_any][]" %>
  <%= search_field_tag "q[name_not_i_cont_any][]" %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE (LOWER(`users`.`name`) NOT LIKE '%mo%' OR LOWER(`users`.`name`) NOT LIKE '%ta%')

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= search_field_tag "q[name_not_i_cont_all][]" %>
  <%= search_field_tag "q[name_not_i_cont_all][]" %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE (LOWER(`users`.`name`) NOT LIKE '%mo%' AND LOWER(`users`.`name`) NOT LIKE '%ta%')

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= f.label :gender_true, '性別' %>
  <%= f.search_field :gender_true %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE `users`.`gender` = TRUE

1
2
3
4
5
<%= search_form_for @q, url: search_users_path do |f| %>
  <%= f.label :gender_false, '性別' %>
  <%= f.search_field :gender_false %>
  <%= f.submit '検索' %>
<% end %>

1
SELECT `users`.* FROM `users` WHERE `users`.`gender` != FALSE