-4

I have data in mysqli table store like that:

-----------------------------
-           skill           -
-----------------------------
- teaching,training         -
-----------------------------
- IT,web programming        -
-----------------------------
- construction, Business    -
-----------------------------

I have data like that and I want to select data that show result like :

teaching

training

construction

web programming

Networking

IT

Bussiness

How can I use mysql to select with that result ?

Community
  • 1
  • 1
Reaksmey se
  • 1

1 Answers1

0

Use normal select data, then use spli string each row with "," as separator.

Split String

or u can use explode

Explode

Sorry, i won't give u the code. You should learn it by yourself. :D

huzain07
  • 1,051
  • 2
  • 8
  • 17
  • thanks you for that. can you give me some example code of this ? – Reaksmey se Aug 08 '15 at 03:04
  • @Reaksmeyse Can you show us the code what have you done so far? – aldrin27 Aug 08 '15 at 03:08
  • just use normal query like "Select job_name from joblist" then when u fetch each row with mysqi_fetch_row use str_split to split each row data. http://www.w3schools.com/php/func_string_str_split.asp – huzain07 Aug 08 '15 at 03:13