Skip navigation links

MySQL Forums :: MySQL Query Analyzer :: How to get the count of like statement is accord in one row


Advanced Search

How to get the count of like statement is accord in one row
Posted by: vahid soufi ()
Date: January 04, 2012 11:31AM

hi
i want to have a query that sort my table with count of success like statement execute in row

like this:

select * from table where paragraph like '%im%' order by (count of success like statement execute in row)

_________________
| paragraph |
_________________
|im vahid glad |
|to meet u | with 1 (im)
_________________
|hello im vahid |
| and im happy | with 2 (im)
_________________

in this case result is

_________________
| paragraph |
_________________
|hello im vahid |
|and im happy |
_________________
|im vahid glad |
|to meet u |
_________________

Options: Reply•Quote


Subject Views Written By Posted
How to get the count of like statement is accord in one row 1362 vahid soufi 01/04/2012 11:31AM
Re: How to get the count of like statement is accord in one row 543 vahid soufi 01/04/2012 01:21PM


Sorry, you can't reply to this topic. It has been closed.
powered by phorum

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.