Profile

Achievement

first submission:submitting first snipplet

apphp-snippets's Recent SnippetsTagged sql



« Prev 1 Next »
Here you may find some useful snippets for calculating relative time for different purposes: to get info from a column within certain date, like the latest 7 days, to get time interval etc.
0 163 posted 6 years ago by apphp-snippets
Lets say you have a table with field called "tags" that consists from tags separated by commas and you want to check whether it includes a required tag. Here the simplest ways of doing that.
0 222 posted 7 years ago by apphp-snippets
Here the simplest way of selecting random rows from the MySQL database with using "ORDER BY RAND()" clause in the query.
0 236 posted 7 years ago by apphp-snippets
« Prev 1 Next »