I am currently getting the error
when trying to run the below query.Quote:
[Err] 1093 - You can't specify target table 'tbl_login' for update in FROM clause
Any help would be much appreciated!
Many thanks in advance for your time.
SET login1 = (
SUBSTRING_INDEX(EMAIL, '@', 1) AS login1