oh absolutely, im not that crazy...

i've done that...but i was hoping i could say something like:

Code: Select all

SELECT * FROM users WHERE (username OR firstname OR lastname) LIKE ('%John%' OR '%Smith%')

just to save some of my sanity. i have tried plugging that in instead of what i have now and it doesnt work properly. you think there is something similar i could say that would work and be not as long and tedious as what i have now?