MySQL | Locate | Find text or word in MySQL

WordPress permalink

MySQL – Locate :

Syntax :-

SELECT LOCATE(‘<< Find STRING >>’,‘<< COLUMN or VALUE’);

Result :

Return the string position

Example :-

SELECT LOCATE(‘Singapore’,‘Malaysia, Singapore’);

Related posts

Leave a Comment