How to use strcmp in if statement in mysql?

[Johnsi George]

sample:

Set @login='USC00010';
set @user='USC00010';
select STRCMP(@login,@user);//returns 0
if(STRCMP(@login,@user)= 0)
THEN
//process1
else
//process2
end if;
and the above code throws You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'if(STRCMP(@login,@user)= 0)

Actual requirement:

if(//matches)
begin
if exists(select X from X )
begin
if exists(select x from x where y=a)
begin
update x
end
end
else//doesn't match
begin
//process2
end

 

[IanWaterman]

Shouldn't syntax be someting like

Set @login='USC00010';
set @user='USC00010';

Begin

if STRCMP(@login,@user)= 0
THEN
//process1
else
//process2
end if;

End;
Ian

 

[ChrisHirst]

How to use strcmp in if statement in mysql

https://www.w3schools.com/sql/func_mysql_strcmp.asp

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.

Never mind this jesus character, stars had to die for me to live.