SQL - Part 22 - instr() MySQL String Function

In this video, I have explained and practically demonstrated using instr() built-in function of MySQL in SQL statements.

[shibbufc]

Im not from IT background but i work in a IT firm. I always thought it must be tough to understand these things. To be honest, it is so easy! Thanks for making it easy for us

[diogokryminice-consultoria]

Anyone who had an error in the SQL database with instr() can use charindex().
select charindex('E', CAR) from CARS for example. Great video and very good content.

[nightowl]

Thank you brother i just want to know the link for using instr is working but everytime a code is written in that page if i remove that to practice instr with other functions it says north.wind can't find customer table so i need to click on customer table in order to proceed

[ifeinUSA]

Hi Arun. First of all thanks for all the videos. These are very helpful. I just came across a small question, if you can help me to figure this out. I am getting an error "Error 1: could not prepare statement (1 not authorized to use function: instr)" when I was running a query Select instr('Gaurav Patel', 'v');

[dasthagirik]

Hi,
In Arun Motoori we have only 'n' is there so output came number 4, If we given Elephent name what is the output will get ?

[pritamgoswami]

I am trying this instr() as you have told but it is not working, every time it is giving error, I checked well that there is no mistake. I am not able to understand what is the problem

[datlarkshivavarma]

@QAFox sir, it was repeating the same( "Error 1: could not prepare statement (1 not authorized to use function: instr)", Once please look into this sir.

[randommagic]

The URL you provided in the comment section isn't working . What to do more for more practice?

[pramodms]

Hi i am getting this error while running this code
SELECT instr(country, "e") FROM [Customers]
Error 1: could not prepare statement (1 not authorized to use function: instr),

[AshutoshShukla-ew]

Error 1: could not prepare statement (1 not authorized to use function: instr), sir mentioned errors are coming during the use of instr string function.
please answer the sir

[gigachad]

Error: could not prepare statement ( 1 is not authorized to use function: instr)

[gnaneshgn]

Nice explanation . Can, I get complete playlist of SQL sir.?

[shivamkhandelwal]

what is the use of this function, this function seems quite useless

[fazulurrehman]

Instr string function not working sir