How to implement search by several keywords in the database?

Question

PHP

How to implement search by multiple keywords from a table.
Requires sorting by time and a certain amount.
I am using redbeanphp.

I do a single label search like this:

$posts_labels = R::findAll('postslabels', 'label = ? ORDER BY `time` DESC LIMIT {$start},{$end}', [$search_text]);
  $posts  = [];

  foreach ($posts_labels as $value) {
    $id = $value->post_id;
    $post = R::findOne('posts', "id = ?", [$id]);
    $posts[] = $post;
  }

how to search for 2 or 3 keywords

Answer 1

Try the R::getAll(); You can write native sql in it, and everything is already there as usual:

SELECT field FROM table WHERE keyword LIKE %keyword% OR keyword2 LIKE %keyword2%...