mysqli prepared statement with operator

Question

Hi,

I am trying to do the following:

$search_query = "SELECT spec, title, quantity, location_to, location_from
                           FROM sm12761.assignments WHERE title = ? LIMIT 0,1 ";

But change it to WHERE title LIKE '&something%'

How would I do this ?

If some one could show me a refactored version of the query that would be great.

Answer 1

append a % to your input string when calling mysqli_stmt_bind_param()

Answer 2

Prepared statements are being precompiled on MySQL's side, so you need to change the query structure, to be able to use LIKE.

$search_query = "SELECT spec, title, quantity, location_to, location_from
                       FROM sm12761.assignments WHERE title LIKE ? LIMIT 0,1 ";