I currently search records with a form and send it to another page with a query similar to the one below. Is it possible to search all records in a table without having to type each column name in the query? Basically a global search that will search all records in a specified table?
SELECT MovieTitle, PitchText, Summary, DateInTheaters
<!--- Search by movie title --->
<cfif FORM.MovieTitle IS NOT "">
AND MovieTitle LIKE '%#FORM.MovieTitle#%'
<!--- Search by tag line --->
<cfif FORM.PitchText IS NOT "">
AND PitchText LIKE '%#FORM.PitchText#%'
<cfif FORM.RatingID IS NOT "">
AND RatingID LIKE '%#FORM.RatingID#%'
ORDER BY MovieTitle