checkedresponsive[@]gmail.com

Menu

MySQL | Locate | Find text or word in MySQL

MySQL – Locate :

Syntax :-

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

Result :

Return the string position

Example :-

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

Leave a Reply

Your email address will not be published. Required fields are marked *