Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL underscore as character
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


Manohar
underscore as character
3 Answer(s)      3 years and 10 months ago
Posted in : SQL


how can i consider _ as a character instead of wildcard character?

my problem is like this

i have 20 records as follows manohar 1234455 manohar 453635 manohar 345454 manohar_1234455

now when i am searching for manohar_1234455, am getting 2 records i.e... manohar 1234455 manohar_1234455

my intention is to get manohar_1234455 record only............. how to resolve this?


Advertisement
View Answers

December 31, 2010 at 9:21 AM


hiiiiii

i got the answer....

we have to replace '_' with '_' then we will get actual result



December 31, 2010 at 2:30 PM


we have to replace '_' with '_' then we will get actual result



December 31, 2010 at 2:31 PM


we have to replace '' with '\' then we will get actual result



Related Tutorials/Questions & Answers:
underscore as character
underscore as character  how can i consider _ as a character instead of wildcard character? my problem is like this i have 20 records as follows manohar 1234455 manohar 453635 manohar 345454 manohar_1234455 now when i am
Underscore b/w consecutive capatalized words
Underscore b/w consecutive capatalized words  I have a text something like this "25km from N of Rio Negro" I want to add underscore between consecutive Capatalized words having space between them. Can some one give me
Advertisements
rexexp pattern to avoid certain words and replace space with underscore
rexexp pattern to avoid certain words and replace space with underscore  I have a text string like "On River Thames in eastern London" and i want to replace space between two capital words with underscore so that "River Thames
JavaScript regex validate Character
. \w shows the word character as all alphabet, numbers and underscore... Character.   <html> <head> <title>Character validation... Character value : "+name); return true; } alert
Character Class
Character Class  Character defines the forDigit();,digit()methods..how can these b used and wht is radix point signifies here...in the arguments of these two???..pls answer a code on this with radix .. are these methods also
Character class
Character class   Character defines the forDigit();,digit()methods..how can these b used and wht does radix point signify here.i want to knw what basically radix is??here in the arguments of these two???because i tried runnin
How to convert entity character to html character
How to convert entity character to html character  How to convert entity character to html character
How to convert entity character to html character
How to convert entity character to html character  Please help me to "convert entity character to html character" in java. If possible please provide source code which take String as input and return as String
replace character in php
replace character in php  PHP script that replace character
Character Wrapper Class.
Character Wrapper Class.  what are Mirrored Unicode Characters?? and whats the use of "isMirrored(ch);method ??.where ch is any character argument.... There are special characters in UNICODE to achieve the RTL. Such character is the Mirroring
character as command line arguments
character as command line arguments  public class testing { public static void main(String args[]) { char a; a=args[0]; System.out.println("character is:"+a); } } what will be the above program output
How to display string or character
How to display string or character  how to print character or a word without using array concept
password validation with special character
password validation with special character  how to validate password with special character using java script
find the first character is vowel or not
find the first character is vowel or not  hi friend, can u plz send me javascript code for find the wether the first character is a vowel or not. 2) check wether the last character is same as the first character or not 3) check
php remove last character
php remove last character  to remove the last character, i used the trim function which is not working
JavaScript regex validate Character
Character   <html> <head> <title>Character validation... Character value : "+name); return true; } alert("It is not valid character !"); return false; } </script> <
What is Character Functions
What is Character Functions  What is Character Functions   Hi, Here is the answer, Character Functions are INITCAP, UPPER, LOWER, SUBSTR & LENGTH. Additional functions are GREATEST & LEAST. Group Functions
Character Directions in java
Character Directions in java  java 2,version 1.4 adds a method "getDirectionality();" , what is the use of this method ?   This method returns the Unicode directionality property for the given character. Character
Wrapper Character class.
Wrapper Character class.  How do the methods 'isIndentifierIgnorable(ch)' and 'isISOControl(ch)' work?? while workin with 'Character' wrapper class...: This method returns true if the character may be part of a Unicode identifier; false
Replace Character in String
Replace Character in String        This example replaces a character with a specified character in a given string. To replace a character with the given character in sting first
Alphabet Character Case-Converter
Alphabet Character Case-Converter   ... a character (uppercase) into a lowercase character. The java.lang package provides the functionality to convert the uppercase character into a lowercase character
J2ME count character into string
J2ME count character into string  i am new in J2ME, my problem is how to count character into number, i had been research google for almost 2 days... form which allow user to input character user input helloworld then press
Unknown Character set: 'utf8mb4'.
Unknown Character set: 'utf8mb4'.  While working on eclipse on an application that uses MySQL as the back end for the database, I was having error...: Unknown Character set: 'utf8mb4'. I'm using WAMPSERVER 2.2 and Eclipse
Determining the type of Character
Determining the type of Character In this section, you will learn how to determine the type of a character. You can use the methods of Character class to determine the properties of a character. This class provides several methods
character literal in octal format
character literal in octal format  class EscapeSequence1 { public...;>> EscapeSequence1.java:6: error: unclosed character literal char... ^ EscapeSequence1.java:6: error: unclosed character literal char ch2
Character count by while loop
Character count by while loop  Write the program to count the number of characters entered until a full stop (.)is keyed-in. Anyone there pls help...]) flag=true; } if(!flag){ System.out.println("Character :"+ch+" occurs "+count
Count the character in java
Count the character in java  Write a java program to count the character â??aâ?? typed by the user in a paragraph by implementing thread.   Count characters by implementing thread import java.util.*; class
character counter - Java Beginners
character counter  how to show only first three characters of the entered(by user) name?  hy katy, import java.io.*; class counter...!!"); } else{ System.out.println("First Three Character is:"+c[0]+c[1]+c[2
illeagal character error....
illeagal character error....   Here is my code: import java.io.*; import java.awt.*; import java.util.*; import javax.swing.*; import...:19: illegal character: \96 ` Container container
Setting the default Java character encoding?
Setting the default Java character encoding?  Setting the default Java character encoding
Find out last character of array
Find out last character of array  How we can find out the last character of array in java program
Advertisements
 

 

 

DMCA.com