PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE MY_TABLE ( ID INT AUTO_INCREMENT, article_title_fld VARCHAR(100), article_tags_fld VARCHAR(100), PRIMARY KEY (ID) ); INSERT INTO MY_TABLE VALUES (1, 'Learn PHP','PHP, coding, scripting'), (3, 'Javascript Tutorial', 'Javascript, scripting, tutorial'), (4, 'Styling with CSS', 'CSS, tutorial, web design');
Copy Clear
Copy Format Clear
<?php // $mysqli is already declared as a working database connection by this sandbox $result = []; foreach ($mysqli->query("SELECT article_tags_fld FROM MY_TABLE") as $row) { array_push($result, ...explode(', ', $row['article_tags_fld'])); } var_export(array_unique($result));
Show:  
Copy Clear