MySQL Forums
Forum List  »  MySQL Workbench

"select" is not valid at this position for this server version, expecting: '(', WITH
Posted by: Lou Radwan
Date: April 01, 2020 11:36AM

Hi,

I am getting this error with:

SELECT d.* FROM display d
JOIN display_field df ON d.set_id = df.set_id AND d.physical_field_number = df.physical_field_number
WHERE databook_id = 6000 AND search_attribute_id IN
(SELECT attribute_id FROM search_field WHERE attribute_type_id = 3) AND cell_text REGEXP [a-zA-Z];

I tried adding parens as another topic mentioned this, but it did not help. What can I do, this seems like any simple query I use daily.

Thanks,
Lou

Options: ReplyQuote


Subject
Views
Written By
Posted
"select" is not valid at this position for this server version, expecting: '(', WITH
239
April 01, 2020 11:36AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.