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)
-
Put this code between <head>...</head> tag. <script type="text/javascript"> function readURL(input) { ...
-
In today's world of web development, working with images is an essential aspect of building a dynamic and visually appealing website. Ho...
-
- There are so many plugins available for build page on WordPress! 1. Elementor: (Free and Paid both plugin available) - Pricing ...
No comments:
Post a Comment