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 <[email protected] > <mailto:[email protected]>> 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
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
