Contains

Hey, I want to try and make my form search my mysql database for the "Name" field containing "search".

This is what i have at the moment
"$Query = "SELECT * from Trainz_files WHERE Name='$search' ORDER BY $Sort $Order";"

Could anyone tell me how i would do this?

Thanks for any help

I think you're looking for the LIKE operator:

Thanks very much that works great 🙂

I have set it out like this and it works great.

$Query = "SELECT * from Trainz_files WHERE Name LIKE '%$search%' ORDER BY $Sort $Order";

But i have one more problem, i need it to also need the "Type" to be = to layout like this

"Type='Layout'"

how could i add this into that.

Thanks

just add it in the query:

$Query = "SELECT * from Trainz_files WHERE Name LIKE '%$search%' AND Type='Layout' ORDER BY $Sort $Order";