tags:

views:

75

answers:

2

I couldn't find anything about this in MySQL documentation.

SELECT accesion_id, 
       definition 
  FROM accesion_table 
 WHERE search_word @@ ? OFFSET ? LIMIT Const.MAX_DISP_COUNT;
+1  A: 

Most likely the code that is executing this sql statement has some parser that's handling this odd syntax, since the the @@, ? and Const.MAX_DISPLAY_COUNT aren't part of MySQL. Also the keyword OFFSET must be placed after the LIMIT keyword.

Ben Rowe
I am sorry, this is postgre sql
umanga
+1  A: 

With Oracle the '@@' to point to the current directory of the executing file. Could it be that MySql might be following Oracles lead?

Peter Tomlins