title: What is wrong with this syntax that works in mysql 5 but doesn't work in mysql 8
body: <p>1064 error in SQL Syntax near '!=guildRank LIMIT 1 END' at line 3</p>
  
  <pre><code>CREATE DEFINER=`root`@`localhost` PROCEDURE `DeleteUserGuildAttr`(IN userId INT unsigned, IN guildId 
  INT unsigned, IN guildRank SMALLINT unsigned)
  BEGIN
       DELETE FROM guildattr WHERE id=userId AND guild_id=guildId AND rank!=guildRank LIMIT 1;
  END
  </code></pre>