Search In
REVERSE(str)
If you want to reverse a string in mysql then you can use the REVERSE(str) mysql function. REVERSE() function returns the string str with the order of the characters reversed means if you want to reverse a string then you can pass the s
REPLACE(str,fromStr,toStr)
When you want to replace a string from other string in a string then you can use REPLACE function. REPLACE function returns the string str with all occurrences of the string from Str and replace it by the string to Str. RE
QUOTE(str)
Quotes function used to produce a result that can be used as a properly escaped data value in an SQL statement of a string. The string is returned enclosed by single quotation marks and with each instance of backslash (“\”), single quote
In php the sizeof() Function returns the number of elements in an array.
Syntax
sizeof(array,mode);
The argument array specifies the array and the mode specifies whether to count multidimensional array or not
the value 0 specifies do not count a
Hello Readers ,
The array_flip() function exchanges all keys with their associated values in an array.
Say we have array array("a"=>"red","b"=>"green","c"=>"blue","d"=>"yellow"); and we want to interchange key and values of an array .
We will understand the process of binding a list box to MySQL by an example. Suppose we have a database "test" having table ex1 which contains columns id,name. We need to bind the name field with the list box. For this we will use the following PHP s
In Python variables in a program which may not be accessible at all locations in python program. This depends on where you have declared a variable and value.
The scope of a variable determines the portion of the program using which we can access a p
Python Variables that are defined inside a function body have a local scope, and those defined outside have a global scope and variable.
That indicate local variables can be accessed only inside the function in which they are declared, whereas global
Hi all,
If you want to change the color of a polyline or route on map just change the color in this delegate of map.
- (MKOverlayRenderer *)mapView:(MKMapView *)mapView rendererForOverlay:(id <MKOverlay>)overlay
{
MKPolylineRenderer *ren
Rails provide us many features which are native to Rails and not ruby.
We can ordinalize a date in rails with a method provided by active_support known as ordinalize.
If we want to ordinalize today's date we can write :-
2.1.5 :01 > t = Time.n
