Retrieve all matches of occurences of words

vanitham · #1 (**permalink**) 07-09-2009

Hi,

I have rows like this.

Code:


Retractor muscle (PRM) of Helix pomatia

Genetic characterization of a prm- mutant

Values of PRM data.

Expression pattern of prmt5 in adult fish.

PRMT-5 negatively regulates DNA

genetic fusions of prM-E protein

Methylation of Xilf3 by Xprmt1b alters its DNA.

protein arginine methyltransferase AtPRMT10

If user specifies "prm*" I want first 6 rows to be selected.

How to write a MySQL query such that first 6 rows are retrieved??

The output should be like this:

Code:


Retractor muscle (PRM) of Helix pomatia

Genetic characterization of a prm- mutant

Values of PRM data.

Expression pattern of prmt5 in adult fish.

PRMT-5 negatively regulates DNA

genetic fusions of prM-E protein

How to retrieve all the variations of prm (i.e if user specifies prm*)?

Any ideas???

How can i do this???

Regards
vanitha

mobi · #2 (**permalink**) 07-15-2009

I would try using SELECT with LIKE '%x%' and LIMIT to the SQL query, for string comparisons you can check this: MySQL :: MySQL 6.0 Reference Manual :: 11.4.1 String Comparison Functions

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
counting the number of occurences	johjoh	Shell Programming and Scripting	3	04-28-2009 06:14 AM
Perl - Count occurences	TimHortons	Shell Programming and Scripting	22	01-31-2009 01:30 AM
no of occurences of q word	Satyak	Shell Programming and Scripting	6	09-29-2008 02:38 AM
occurences of words	vanitham	Shell Programming and Scripting	3	09-24-2008 04:53 AM
How to find all occurences of word?	vanitham	Web Programming, Web 2.0 and Mashups	0	09-06-2008 05:35 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by