Query Operators

[minigts]

I'm new to this forum and was interested in finding a pretty comprehensive list of operators used in searching databases. I've been working with Siebel for a while, but haven't ever seen any documentation with any of the different companies as to all the queries that work within the application. It does use an SQL db engine I believe, but I wasn't sure where this post should go.

Any advice or direction on operators even other applications would be appreciated. I'm looking really for any operator that allows for searching by date. I know of the TODAY operator, but would like to know if there are any more date-based ones.

Thanks!

[ronverdonk]

Do you want to search for text (any) in your tables or do you want to search specific columns, such as date/time or blobs?

Ronald :cool:

[minigts]

Thanks for the reply. I would like to be able to search, text, number and date fields. An inclusive list is what I have been looking for, but unable to find.

Thanks in advance for any information.

[ronverdonk]

Maybe I did not pose the question in the right way. What I wanted to say was what kind of queries are you looking for? There are (my distinction) 2 kinds of queries:

looking for a specific value in specific column or columns, such as you would specify in e.g.

SELECT start_date, end_date FROM holidays 
WHERE start_date='2006-10-20' 
AND end_date < '2006-11-01'

or you can search the database for the occurrence of a piece of data over a whole row with an expression, such as searching for the occurence of the string 'janitor' in a table 'jobs'. Such as:

        SELECT code, function, description, announcement
        FROM jobs 
        WHERE function REGEXP '$search_word'
        OR description REGEXP '$search_word'
        OR announcement REGEXP '$search_word'
        ORDER BY code

I hope I made myself clearer now.

Ronald :cool: