MySQL Forums
Forum List  »  Oracle

Funcion INSTR
Posted by: Fabio Castillo
Date: August 16, 2009 12:00PM

Hola a todos soy nuevo en Mysql como obtengo este resultado pero en MYSQL

Esto es Oracle

i ejecutamos:

SELECT INSTR('1,2,3',',',1,2) FROM CONTENIDO;

Devuelve
encontrò 2 comas por este registro
2

Ahora hay que tener en cuenta que yo tengo una tabla y la idea seria asì

SELECT INSTR(ID,',',1,2) FROM CONTENIDO;

Me retorne en nuemro de comas por cada registro


Como se hace pero con MySQL?

Gracias



Edited 2 time(s). Last edit at 08/16/2009 12:29PM by Fabio Castillo.

Options: ReplyQuote


Subject
Views
Written By
Posted
Funcion INSTR
9623
August 16, 2009 12:00PM
7026
August 17, 2009 02:38PM
4098
August 18, 2009 10:34AM
3923
August 18, 2009 12:58PM
4255
August 18, 2009 04:32PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.