SQL format output

kdelover · 10-11-2012, 12:00 PM

Hi Folks,

Does any one know of any function in SQL that lets me format the output returned from a SELECT query ? From the output below,id like to get anything that is to the left of '-'. I can do this in a programming language butid like to try this through SQL.

Quote:

mysql> select post from table where col like 'z%';
+-------------+
| post |
+-------------+
| Z01-C3 |
| Z101-ZZ1 |
| Z21-PG4 |
| Z8202-G21 |
----------------

Intended output:
Z01
Y101
R21

Wim Sturkenboom · 10-11-2012, 01:00 PM

http://dev.mysql.com/doc/refman/5.0/...ubstring-index should do the trick

Habitual · 10-15-2012, 09:19 AM

Code:

mysql -e "use zabbix; select description from triggers;" -Ns

output:

Code:

...
WEB (HTTP) server is down on {HOSTNAME}
Zabbix_agentd is not running on {HOSTNAME}
Zabbix_server is not running on {HOSTNAME}
{HOSTNAME} has just been restarted
Version of zabbix_agent(d) was changed on {HOSTNAME}
WEB (HTTP) server is down on {HOSTNAME}
Server {HOSTNAME} is unreachable
rdp on {HOSTNAME} is unreachable
...