Rails 5, how to fetch database from multiple fields?

Question

PostgreSQL

The bottom line is this, I make a user search panel on the page, and process the entered values ​​as follows:
users = User.where("first_name LIKE ? or last_name LIKE ?", "%#{params[:search]}%",
"%#{ params[:search]}%") if params[:search].present?
If you search only by first name (first_name) or last name (last_name), then everything works fine, but if you enter the first and last name at once, for example, "Ivan Ivanov", then the search does not work accordingly.
I'm not good at querying the database, can you tell me how to process another option with the entered first name and last name at the same time?

Answer 1

I found it myself, everything turned out to be quite simple, the code will take the following form:
users = User.where("first_name || ' ' || last_name like ?", "%#{params[:search]}%") if params[: search].present?