1

I need to split space delimited string :

myTable.myColumn
'KR11 KN22 M33 CH44'

I was try this code below

SELECT * 
FROM myTable
WHERE CHARINDEX(' ',myColumn) = 0

but It returns an error :

ERROR 1305 (42000): FUNCTION myDB.CHARINDEX does not exist
adjieq
  • 99
  • 1
  • 11
  • http://stackoverflow.com/questions/9953114/split-comma-delimited-string-function-db-charindex-does-not-exist – jophab May 06 '17 at 12:52
  • Possible duplicate of [How to split the name string in mysql?](http://stackoverflow.com/questions/14950466/how-to-split-the-name-string-in-mysql) – Ben May 06 '17 at 12:53
  • Edit your question and provide sample data and desired results. – Gordon Linoff May 06 '17 at 12:55

0 Answers0