MySQL Forums
Forum List  »  Newbie

Select Statement Output
Posted by: carlo s
Date: December 14, 2009 02:58PM

I loaded Kiwi on a windows VM to handle all of my syslog data, then I'm shipping the data through a MySQL ODBC connection to a MySQL database. The "MsgText" field as you can see from the output below contains a good bit of information. When I run a select query I only want to display specific data in the query results window. Do you know what syntax I would need to pull specific data from the MsgText column? Example, It would be nice to display just the following text "denied udp 169.254.1.255". Also, when people build dynamic front-end web pages what do they use to pull data from a back-end database, Apache coupled with PHP?

**Current Query**
use kiwi;
select MsgTime, MsgText from Syslogd where MsgText like '%5000%' and MsgTime < '8:00:00' order by MsgTime DESC limit 0,8;


**Snippet of the MsgText Data**
Dec 13 2009 05:45:33: %PIX-2-106100: access-list out denied udp outside/169.254.1.136(44890) -> outside/169.254.1.255(5000) hit-cnt 20 300-second interval [0x6a852657, 0x0

Options: ReplyQuote


Subject
Written By
Posted
Select Statement Output
December 14, 2009 02:58PM
December 15, 2009 08:44PM
January 02, 2010 07:36PM


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

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.