You can add the title search into Tamil's query in a couple of
ways:
1. Title specifically matches something:
SELECT *
FROM search_groups
WHERE category_id IN ( 51, 135, 136 )
AND resource_title = '????';
2. Title contains some string:
Begins with it:
SELECT *
FROM search_groups
WHERE category_id IN ( 51, 135, 136 )
AND resource_title LIKE '%';
Contains it:
SELECT *
FROM search_groups
WHERE category_id IN ( 51, 135, 136 )
AND resource_title LIKE '%%';
Ends with it:
SELECT *
FROM search_groups
WHERE category_id IN ( 51, 135, 136 )
AND resource_title LIKE '%';
You could also use the INSTR function or depending on your version you can use Oracle Text (check out CTXCAT in version 9 and up). You may also have to deal with multiple keywords on your search.
____________________
Pete