i feel like to comment mailing-list basics * DON'T top-post, you are destryoing threads * DON'T convert plaintext posts to HTML * DON'T reply-all, the reply button results in a off-list answer Am 19.03.2014 16:25, schrieb Peter Laursen:
I feel like to comment here on "because it can't use indexes for such things". This is not a serious reply IMO. It is just another way or saying "Please shut up!"
it is serious and don't insinuate words one have not said there is a) no such function and b) no benefit of it
How many existing string functions (http://dev.mysql.com/doc/refman/5.6/en/string-functions.html) use an index? Does "select concat('a','b');" do for instance?
that does not read and seek anything in a column frankly "select concat('a','b');" is the same as "ab"
I cannot think of any. And why do we have 'stored programs' if a database server should only do things that uses indexes? Does a WHILE-loop inside a stroed program use an index?
surely can someone discuss what should be donme
Unlike most other RDBMS, MySQL has a tradition to do things in the application thet other RDBMS would do in the database. But that traditions is/was because of lack of functionality in the server before 5.0 (what is still the case in some respects. Try compare a MySQL TRIGGER with an Oracle or SQL Server same, for instance).
That said: this functionality can be implemented in a stored function using existing string functions (or in the application, as sugggested) quite easily
maybe
It is not possible (or desirable) to add build-in functions for everything
which was my point
And I have no clue is such string function exists in other RDBMS.
unlikely
On Wed, Mar 19, 2014 at 4:03 PM, Reindl Harald <h.reindl@thelounge.net <mailto:h.reindl@thelounge.net>> wrote:
Am 19.03.2014 15:51, schrieb Roberto Spadim: > hi guys, i'm not finding a function to return how many character i have, for example: > > "banana" > > i want a function that return 2 "n" characters, example: > substr_count("banana","n") => 2 > > sorry it a begginners question, but i didn't found it in mysql/mariadb manual
that is not the job of the database server because it can't use indexes for such things - just iterate the result and do it in the application