CODEWITHSUNDEEP
mysqlsql
Ashika Umanga Umagiliya
Ashika Umanga Umagiliya

Reputation: 9178

What does double "at" (@) marks mean in this SQL query?

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;

Upvotes: 6

Views: 2349

Answers (2)

Peter Tomlins
Peter Tomlins

Reputation: 24

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

Upvotes: 0

Ben Rowe
Ben Rowe

Reputation: 28721

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.

Upvotes: 2

Related Questions