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?
|