List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:August 21 2009 6:55am
Subject:Re: alternate in mysql
View as plain text  
Hi Johnny,
Thanks for the reply, but the below sql does not seems to work

 SELECT * FROM tmp WHERE t REGEXP '^/sr/db/.*';
Empty set (0.02 sec)


mysql> SELECT * FROM tmp WHERE t REGEXP '/sr/db/.*';
+----------------------------------------------------+
| t                                                  |
+----------------------------------------------------+
| asdf
/sr/db/ora/ora.ora
/sr/db/ora/aaa.ora
asdlkjf |


On Thu, Aug 20, 2009 at 8:19 PM, Johnny Withers <johnny@stripped>wrote:

> You could try:
>
> SELECT * FROM tmp WHERE t REGEXP '^/sr/db/.*';
>
> On Thu, Aug 20, 2009 at 9:15 AM, Ananda Kumar <anandkl@stripped> wrote:
>
>> Hi All,
>> I have this data in both oracle and mysql.
>>
>> select * from tmp;
>> T
>> --------------------------------------------------
>> asdf
>> /sr/db/ora/ora.ora
>> asdfljk
>> asdlkjf
>>
>> asdf
>> /sr/db/ora/ora.ora
>> /sr/db/ora/aaa.ora
>> asdlkjf
>> Where t is a varchar column, with each row having multiple lines.
>> I can write this query in oracle to fetch only rows starting with ''sr/db"
>>
>> select substr(t, instr(t, '/sr/db/'), instr(substr(t, instr(t, '/sr/db/'),
>> length(t)), chr(10))) from tmp;
>> /sr/db/ora/ora.ora
>> /sr/db/ora/ora.ora
>> where chr(10) ..represents "NEW LINE" in oracle
>>
>> How do i do the same in mysql.
>>
>> Thanks for all you help.
>>
>> regards
>> anandkl
>>
>
>
>
> --
> -----------------------------
> Johnny Withers
> 601.209.4985
> johnny@stripped
>

Thread
alternate in mysqlAnanda Kumar20 Aug
  • Re: alternate in mysqlJohnny Withers20 Aug
    • Re: alternate in mysqlAnanda Kumar21 Aug
      • RE: alternate in mysqlJerry Schwartz21 Aug
        • Re: alternate in mysqlJohnny Withers21 Aug
          • Re: alternate in mysqlAnanda Kumar7 Sep