dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tip: Using the Locate Command in MySQL

Finding a particular string in a large data set can be extremely tedious. Fortunately, MySQL has a command called locate to help you find what you need.


advertisement

WEBINAR:

On-Demand

Building the Right Environment to Support AI, Machine Learning and Deep Learning


Amid tons of data, finding a particular string's presence in the data is extremely tedious. MySQL has a command named LOCATE that can be used with certain conditions and the yield is truly useful.

Using the LOCATE Command

LOCATE ("<search string>", column_name, <start index - Optional>)

For example, if we are trying to look for a string called "JAMES" in the column NAME from a table named EMPLOYEE_DETAILS, the following SQL will be able to make the needed query.

SELECT LOCATE("JAMES", NAME) FROM EMPLOYEE_DETAILS; 

Assuming there are 5 records in the table and the values JAMES is present in row # 3, the output will be as follows.

+ -- -- -- -- -- -- -- -- -- -- -- -- -- +
|LOCATE("JAMES", NAME) |
+ -- -- -- -- -- -- -- -- -- -- -- -- -- +
| 0 |
| 0 |
| 1 |
| 0 |
| 0 |
+ -- -- -- -- -- -- -- -- -- -- -- -- -- +

 

Visit the DevX Tip Bank

 





   
Sridhar M S. is a Java developer from Bangalore, India. He holds a master's degree in Computer Science.
Thanks for your registration, follow us on our social networks to keep up-to-date