Keyword Search
[198 byte] By [AlaNioa] at [2007-11-27 5:49:21] 
I'm trying to implement a keyword search. I currently have one using LIKE %keyword% but this doesn't work for multiple words. Is there a way of implementing a multiple word one ? Using DB2.
# 1
Presumably this is with a small dataset.You would have to dynamically build up the SQL in code that does the search. This would result in SQL that looks like....1 keyword = where (f like '%key1%')2 keyword = where (f like '%key1%') and (f like '%key2%')jschella at 2007-7-12 15:35:45 >
Database Connectivity Hot Topic
- jdbc
- how to hide username/password in JDBC program.
- Can i store file in Database?
- JDBC Driver Problem
- Maximum Parameters for PreparedStatement
- Instantiation Error in JAR file
- number of rows returned by SELECT LAST(column)
- PreparedStatement
- I have name of a savepoint, can i rollback to that savepoint?
- JDBC INSERT PROGRAM
- COUNT field incorrect or syntax error
- Problem with recycling connection pool
Database Connectivity
All Classified
- Archived Forums
- Enterprise & Remote Computing
- Java Essentials
- Desktop
- Core
- Solaris Operating System
- Security
- Database Connectivity
- Java Mobility Forums
- Web & Directory Servers
- Development Tools
- Application & Integration Servers
- Java HotSpot Virtual Machine
- Other Topics
- E-Mail, Calendar, & Collaboration
- Developer Tools
- General
- Administration Tools
- Sun Hardware
- Storage Forums
- Java Enterprise System
- StarOffice
- Open Source Technologies
- BigAdmin
- Real-Time
- Java Coding