Greetings: Does anyone know of a standalone string function in MySQL that can return the number of occurrences of a string within field? I need this for a CREATE TABLE / INSERT FROM exising_table implementation and am trying to keep the number of parsing functions to a minimum.
Is FIND_IN_SET appropriate for this? i.e. does SELECT FIND_IN_SET("str2find", field_with_0-n_of_str2find); > 0 Is that efficient for inserting/updating large rowsets? Thanks, Van -- ================================================================= http://www.dedserius.com/ - Linux rocks!!! ================================================================= -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]