Mobi Wan

Could someone kindly clarify... That is, when the pattern that we are matching does not begin with the same letter as the main text... String: abcdbcx, for example bc pattern If so, please explain how. I read it on scaler topics but didn't understand it. completely

In Java, if I try to do.equals() on a null string, a null pointer error is issued. I'm wondering whether I can perform the following if I'm attempting to compare if a string is equal to a constant string:

MY CONSTANT STRING.equals(aStringVariable)

I'm sure it'll work, but is this simply extremely bad code?
This is a common Java idiom known colloquially as a Yoda condition. Personally, I prefer to handle the null situation directly, but the Yoda method is widely used, and any competent Java programmer should quickly grasp what is going on. How should I proceed?

You cannot mention multiple column names with commas using ADD COLUMN. You need to mention ADD COLUMN every time you define a new column. You can utilize the SQL group by clause to organize identical data into groups. The group by single column function groups all entries that have the same value in only one column.

Try this instead: 

local function RemoveHarvestSoul(event, player, spell, skipCheck)
    if ((spell:GetEntry() == 42833) and player:HasAura(28679))
    then
        player:RemoveAura(28679)
    end
end
 
RegisterPlayerEvent(5, RemoveHarvestSoul)