View Single Post

  #1 (permalink)  
Old 05-24-2008
Andrzej Kubaczyk
 
Posts: n/a
Default How to get a part of field in select qurey?

Hello.

In the table I have one column where I storage some data in format:
Ac01,bc32,45sw
Field contains a few part of data coma separated.

+----------------+
| types |
+----------------+
| Ac01,bc32,45sw |
| df22,Ac45 |
| dd22 |
| we23,rd34,Ac33 |
+----------------+

I need to get a part of the field, for example data pass to pattern Ac
%

Demand result is:
Aco1
Ac45
Ac33

Do somebody knows how to do it using mysql function?
Reply With Quote