SQL LOCATE command

You can use LOCATE command to find a position of string inside another one for instance :

Code:

select locate('ah',aewgahrta)

This query will return 5. You can also use LOCATE keyword in the where clause :

Code:

SELECT * FROM 'Department' WHERE locate( 'IT', name )

The previous search for the existence of sub string "IT" in the column name. You also print the location of sub-string for each record.

Code:

SELECT locate('IT',name) as position,name FROM 'Department'

_________________
M. S. Rakha, Ph.D.
Queen's University
Canada

Author: DrRakha
Mastermind

Posts: 2715
Have thanks: 74 time

Page 1 of 1

[ 1 post ]

Related Posts to : SQL LOCATE command
BETWEEN SQL COMMAND -
SQL ALTER Command -
Calling the man Command -
SQL GROUP BY Command -
SQL DISTINCT Command -
Average SQL command -
PHP echo command -
SQL COUNT Command -
JVM does not recognize MQ command. -
SQL LIKE query Command -

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com