Search by beginning of word sql and php?

Question

PHP

I want to get the value at the beginning of the entered string... I wrote the following pseudo-query:

$second_name = $db_site->query("SELECT * FROM wp_users WHERE second_name = LIKE ('".$string."%') ")->fetch_assoc()['second_name'];

All code after this line dies, what's wrong, tell me please...

Answer 1

you need to use match against

Answer 2

If "dies" means "works slowly", then put the index.
If it dies, it means it stops working but does not give errors - you need to turn on error output, read it and fix it.