Re: Dynamically Change Query Based on User Input via PHP

[Rick James]

> I'd have to write it out 64 times! (2 to the 6th power)
Unmaintainable.

Here's some examples of how to do it 6 times instead of 2**6:
http://forums.mysql.com/read.php?10,381333 (Not working in MYSQL5.1)
http://forums.mysql.com/read.php?52,363838 (Problem with search when add BETWEEN to query)
http://forums.mysql.com/read.php?52,264473 (mutiple field query)
http://forums.mysql.com/read.php?10,247890 (write trim into INSERT and SELECT Queries)
(I claim those examples are even simpler.)

You may have to escape the strings instead of using bind.