06-25-2008, 09:59 PM
|
|
Registered User
|
|
Join Date: Jul 2004
Posts: 249
|
|
Here's an example:
Quote:
|
SELECT * FROM bible WHERE 1=1 AND CASE WHEN text_data LIKE '%bring%' THEN 1 ELSE 0 END + CASE WHEN text_data LIKE '%Aaron%' THEN 1 ELSE 0 END + CASE WHEN text_data LIKE '%remnant%' THEN 1 ELSE 0 END + CASE WHEN text_data LIKE '%offering%' THEN 1 ELSE 0 END + CASE WHEN text_data LIKE '%Aaron%' THEN 1 ELSE 0 END > 3 LIMIT 0, 10
|
|