Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Coluna X Linha
#MySQL 5.7.12 #please drop objects you've created at the end of the script #or check for their existance before creating #'\\' is a delimiter select PARCELA, SUBSTRING_INDEX(SUBSTRING_INDEX(SUATABELA.PARCELA, '/', NUMEROS.NUMERO), ',', -1) P from (select 1 NUMERO union all select 2 union all select 3 union all select 4 union all select 5) NUMEROS inner join (select '30/60/90' PARCELA) SUATABELA on CHAR_LENGTH(SUATABELA.PARCELA) - CHAR_LENGTH(replace(SUATABELA.PARCELA, '/', '')) >= NUMEROS.NUMERO - 1 order by PARCELA, NUMERO
run
|
edit
|
history
|
help
0
ITM_14210069
Employee
MySQL: comparison including "IS NULL" cases
MySQL Practice
dhin
mysql - having
Pivot Table test
MySQL is added
ITM_14210069
par