See above shows a database table contains 2 fields id and name..
I need to search these values and display the names with a keyword entered by user.
The key word may b a string or even a character say "A","5HT1E","4".....
The problem is i need to check the keyword only in the part before the "_" from the name field....
suppose an user enterd a keyword "A", my expected results are A4_HUMAN,ABC3H_HUMAN..
The string 22P1_RAT & 5HT1E_HUMAN also contains the keyword "A" but it is after the"_" symbol..so i don;t need it as the result..
So kindly provide me the query using 'like' operator...
How can i write the query?????? :(