Hi there ! I wanna know if the reverse of the function SUBSTRING_INDEX exists or not. --DESCRIPTION--- ============== >SUBSTRING_INDEX(str,delim,count) >Returns the substring from string str before count occurrences of the delimiter delim. >If count is positive, everything to the left of the final delimiter (counting from the left) is returned. >If count is negative, everything to the right of the final delimiter (counting from the right) is returned: --MY NEED-- ========== Now if i have the "str" (string) and the "delim" (delimiter), how can i know the "count" (Number of occurences) ?!? Many thanks for your support. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php