I want to select the row of my mysql database which contains a word from a string, which is a php variable.
I found two ways:

```
"SELECT * FROM table WHERE '$string' REGEXP word_column"

```

and

```
"SELECT * FROM table WHERE '$string' LIKE CONCAT('%',word_column,'%')"

```

For example, if my database is:

```
id | word_column
 0 | red
 1 | blue
 2 | green
 ...

```

Then 

```
<?php
...
$string = 'This string contains word red, so I want mysql to return row 0!';
$best_query = ""; //HERE GOES ONE OF THE QUERIES ABOVE
$result_i_want = mysqli_query($db_connect, $best_query);
...
?>

```

Both queries works, but which is the one with best performance?