|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Codewalkers Forums Sponsor:
|
 AT&T devCentral & BlackBerry(r) Webcast Series: BlackBerry and GPS -Build Location Awareness into your BlackBerry Applications, July 10th-1:00PM EST. Register Today!
|
|
#1
April 24th, 2003, 06:13 AM
|
|||
|
|||
|
Locate Function
Hi i found this is the mysql manual but want to know is there a way to return subsequent occurances of a substring and not just the 1st 1?
LOCATE(substr,str) POSITION(substr IN str) Returns the position of the first occurrence of substring substr in string str. Returns 0 if substr is not in str: mysql> SELECT LOCATE('bar', 'foobarbar'); [moved to Database Help by xs0]
|
|
| Viewing: Codewalkers Forums > Other Technologies > Database Help > Locate Function |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
