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]

Reply via email to