Here is example for use GROUP_CONCAT, DISTINCT and SEPARATOR in single sql query,
Example:
SELECT group_concat(distinct (id) SEPARATOR ', ') AS ID FROM (tablename) WHERE 1=1
Enjoy!
Subscribe to:
Post Comments (Atom)
The Future of Technology: Emerging Trends to Watch in 2025
Introduction As we navigate through 2025, the technological landscape continues to evolve at an unprecedented pace. Innovations that once se...
-
Put this code between <head>...</head> tag. <script type="text/javascript"> function readURL(input) { ...
-
$no = 5; $no2 = 10; $no3 = 6; $maxVal = max($no,$no2,$no3); echo $maxVal; Result: 10
-
If you want to change page title from admin side then please follow below steps: * Login in admin and open CMS > Static pages, th...
No comments:
Post a Comment