using wildcards

[greatepier]

I currently have a query for records coded as:

$Opdracht = "SELECT * FROM binary_data WHERE id like '$zid' AND Achternaam like '$ZAchternaam' AND Voornamen like '$ZVoornamen' AND Doctype like '$ZDoc' LIMIT 0 , 30 ";

This works, but in my submit form I need to add a % to get all records e.g. starting with ABC. So I have to submit ABC% to find e.g. ABC, ABCD or ABCF.

Can I add the % sign automaticly to the variable?

[spyro187]

Sure, say the variable is $text

Just do something like $text=$text."%";

It may need to be $text="$text%";

Check my syntax but that should work.

[greatepier]

Thanks the last syntax worked !