1
Download Developing Web Applications with ColdFusion
Transcript
Chapter 9: Building Search Interfaces 139 Performing Pattern Matching Use the SQL LIKE operator and SQL wildcard strings in a SQL WHERE clause when you want to compare a value against a character string field so that the query returns database information based on commonalities. This is known as pattern matching and is a very common search scenario. • Surround strings in SQL commands with single quotes (’).
