This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dev:sql:examples:home [2010/07/02 06:46] tdo |
dev:sql:examples:home [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| {{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
| ====== Omnidex SQL Examples ====== | ====== Omnidex SQL Examples ====== | ||
| {{page>:sql_bar&nofooter&noeditbtn}} | {{page>:sql_bar&nofooter&noeditbtn}} | ||
| ===== $CONTAIN Function ===== | ===== $CONTAIN Function ===== | ||
| - | SELECT FIRST_NAME FROM CUSTOMERS WHERE $CONTAINS(FIRST_NAME,'fred,'SYNONYMS=ALL_GIVEN_NAMES') | + | SELECT FIRST_NAME FROM CUSTOMERS WHERE $CONTAINS(FIRST_NAME,'fred,'SYNONYMS=ALL_GIVEN_NAMES'); |
| - | SELECT FIRST_NAME FROM CUSTOMERS WHERE \ | + | SELECT FIRST_NAME FROM CUSTOMERS WHERE |
| - | $CONTAINS(FIRST_NAME,'fred,'SYNONYMS','LIST=ALL_GIVEN_NAMES') | + | $CONTAINS(FIRST_NAME,'fred,'SYNONYMS','LIST=ALL_GIVEN_NAMES'); |
| - | SELECT FIRST_NAME FROM CUSTOMERS WHERE $CONTAINS(FIRST_NAME, \ | + | SELECT FIRST_NAME FROM CUSTOMERS WHERE $CONTAINS(FIRST_NAME, |
| - | '(SYNONYMS(fred,"ALL_GIVEN_NAMES"))') | + | '(SYNONYMS(fred,"ALL_GIVEN_NAMES"))'); |
| ===== Qualify Statement ===== | ===== Qualify Statement ===== | ||