I usually clean the data pretty rigorously and then concatenate strings.
Do you use prepared statements or concatenate strings to create MySQL queries? Why?
I have some older systems where I use concatenation, but I've been using prepare for newer code.